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
 
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

Query Returning Multiple Results 1
Append query wont run because: 8
working out the day from the date 2
Missing Calculated Age Values 5
Why does MSAccess cut query after 2886000 records 1
Remove a result from a query 2
Query producing different results each time it is run 2
Searching for Missing Data 1

Back
Top