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

I've used that work-around myself when faced with a report that's going to
require overly complex queries.  Not your case exactly but I got the idea of
the temp table years ago from this list.  I like the temp table approach
because you can lay out the table with exactly the fields you want on the
report and populate t with data instead of FKs. Use a bit of code to open a
recordset to get the basic data - loop through it filling the target table
and walla!  Report.

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 12:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Report - One field for one Customer is Missing

Rocky, David, Gary, Doug,

Thanks for all of your ideas/insights.

I used every idea as I tried to debug this problem.

One thing that I failed to mention earlier is that the underlying query is
pulling data from several other queries.  In other words it is complex.  It
appears that when the complexity of the queries is combined with the report
(which has sorts and filters), the Access gods are angered.

I changed the report's query to be a "Make Table" query and then I changed
the report's data source to this new temporary table.  This fixed the
problem.

I don't fully understand what Access does behind the scenes, but apparently
the underlying queries are somehow combined with the report filters and in
some cases that does not work properly.

I really appreciate all of the help.  I am the "Lone Ranger IT person"
with no one else onsite to consult with.  Your assistance on this issue and
on many prior problems has been outstanding.

Thanks again,
Brad 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, October 11, 2013 11: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

--
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=F150F27DED.CF9D0



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com