[AccessD] Access Report - One field for one Customer is Missing

Brad Marks BradM at blackforestltd.com
Fri Oct 11 11:22:45 CDT 2013


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



More information about the AccessD mailing list