Brad Marks
BradM at blackforestltd.com
Fri Oct 11 14:49:39 CDT 2013
Rocky, David, Gary, Doug, Thanks for all of your ideas/insights. I used every idea as I tried to debug this problem. One thing that I failed to mention earlier is that the underlying query is pulling data from several other queries. In other words it is complex. It appears that when the complexity of the queries is combined with the report (which has sorts and filters), the Access gods are angered. I changed the report's query to be a "Make Table" query and then I changed the report's data source to this new temporary table. This fixed the problem. I don't fully understand what Access does behind the scenes, but apparently the underlying queries are somehow combined with the report filters and in some cases that does not work properly. I really appreciate all of the help. I am the "Lone Ranger IT person" with no one else onsite to consult with. Your assistance on this issue and on many prior problems has been outstanding. Thanks again, Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, October 11, 2013 11:23 AM To: Access Developers discussion and problem solving Subject: [AccessD] Access Report - One field for one Customer is Missing All, This is one of the strangest things that I have seen for a long time. We have a Sales Order report that has been used for several months. Recently one of our users pointed out that the Customer Name was not being shown for a specific customer. There are 7 fields shown for each customer on the report. All of the fields are shown for all customers, except one. For this one customer, only 6 of the 7 fields are shown. Here is where things get really interesting... When I look at the data from the underlying query, I can see all 7 fields for this customer. In other words, all of the data is visible in the Report's data source (underlying query), but not all of the data is being shown on the report. Any ideas or suggestions would be appreciated. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=F150F27DED.CF9D0