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

David,

I checked the field alignment and I added the same field to a second
place on the report.  The error still surfaced.

Thanks for your help.

Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Friday, October 11, 2013 11:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Report - One field for one Customer is
Missing

Could it be something silly like a field that is right aligned and
excess white space at the end of that one customer field?

can you put a label somewhere on the report for Sh|ts and giggles that
uses the same control source as the suspect text box?




On Fri, Oct 11, 2013 at 9:46 AM, Brad Marks
<BradM at blackforestltd.com>wrote:

> 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
>
>
>
> --
> 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=82C7927DED.D5388