Records Missing from Report

  • Thread starter Thread starter MarshaM
  • Start date Start date
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?
 
Do you have criteria set for the query?
What is an example of record not pulled?
Post your query SQL.
 
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.
 
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!!!
 
Back
Top