Query data not showing on report

  • Thread starter Thread starter DaveInPNG
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Query Works 2nd Time, But Not 1st 14
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1
Filter within a report 4
Not all data in fields is showing up in query 5
Fields not showing on Report 7
queries which pull data in multiple "rows" in one table and compar 2
report error message 1

Back
Top