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

Doug Steele dbdoug at gmail.com
Fri Oct 11 12:49:39 CDT 2013


Can you edit the customer master record? Try clearing the Name field and
re-entering it, then see if that fixes the problem.

Doug


On Fri, Oct 11, 2013 at 10:13 AM, Gary Kjos <garykjos at gmail.com> wrote:

> I would export the data for the report - from a query I presume - to a TXT
> format file and then look at that file with a hex viewer and see if there
> are weird and possibly unprintable characters involved.
>
>
> On Fri, Oct 11, 2013 at 11:22 AM, Brad Marks <BradM at blackforestltd.com
> >wrote:
>
> > 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
> >
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list