[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