Records Missing from Report

M

MarshaM

Some of my records do not flow over to the query result or report. They do
not have any special filter and the query does not rule them out. It seems
random as I cannot find 1 specific commonality between these records that
would differentiate them from the ones that show. They are imported from the
same application as the records that show. I have +7,000 records. Any
suggestions?
 
K

KARL DEWEY

Do you have criteria set for the query?
What is an example of record not pulled?
Post your query SQL.
 
J

Jerry Whittle

To add to Karl's questions, are there more than one table joined in the
query? Often it's just a case of an inner join between tables with one not
having a matching record.
 
M

MarshaM

I think you've hit on the answer, Jerry. My query was built on another query
which had multiple joins and one didn't have the right properties. Thanks so
much!!!
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
query to show where no data in a stated column 0
QBF & Query Malfunction 0
Duplicate records suppressed 7
How do I generate a random selection query in Access? 1
Query to pull all records for those missing records 5
Counting Yes/No responses from multiple records in a table 8
Random Function for Selecting Records 6

Top