Brad Marks
BradM at blackforestltd.com
Fri Oct 11 11:46:50 CDT 2013
Rocky, Thanks for the help. I found an earlier version from the first part of September. I ran a test with this version and the problem surfaced with this older version also. I think that either the problem has existed for a long time and it was never pointed out, or there is something really strange about the data for this one customer. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, October 11, 2013 11:32 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Report - One field for one Customer is Missing Do you have an earlier version of the mdb where the report does work? If so, you could import that report into the current version. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, October 11, 2013 9: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 -- 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=B537727DED.DC8F0