Missing Results

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey...


I have created a query which basically calcluates feild from different
tables. But have noticed that some other the records are missing from
my results. I have 2322 records in my database and when i run the query
there is only 1849 records appear..!! Anyone any idea why this is???

Fie
 
Do you have any criteria in your query that would limit the number of
records displayed? You say you have two tables, how are the relationships
built? If you are only pulling records where both tables are equal, you
might be missing some.
 
i do have criteria that limits some of the results as the Profit must
be greater that 23... but some of the results that are missing have
profits greater than 23... mmmm
 
Back
Top