Query data not showing on report

D

DaveInPNG

I've written a query using data from multiple tables in the same
database (with relathionships). The query gives me the results I
expect.

However, when I using the report wizard or manually create a report
using the query as the data source, I only get some of the data records
the query returns. I'm not using any filters on the report itself. If I
create a new report, I still only get some of the records.

Why does the report not show all of the queried data?

I'm using Access 2002 SP3.
 
W

Wayne Morgan

If the query returns the correct results, you've created a new report, and
there is no filtering, grouping, limiting textboxes to "no duplicates", or
limiting the number of records returned in the report, then corruption is
the only thing I can think of. Try a new mdb file, import just the tables
and the query in question, then create a new report in that file and see if
that works.
 
Top