Strange query behavior

R

Ray C

I have a query that returns 15476 records.
I decided to turn it into a make table query.

When I open the query and filter one column with a certain value I get 5
records.
When I do the same filter on the table I get 4 records.

....Yet, both my table and my query have 15476 records!

Has this ever happened to anyone.

What's even stranger is when I open the query I can only visually find 4
records that match my "certain" value I filtered earlier.

Can anyone explain this one?

Thanks!
 
J

Jerry Whittle

Instead of filtering the query using menu bar tools, put in the criteria in
the query.

I don't much trust the filter tools especially on a query. You are asking a
question of a question. I'd rather just ask one question with proper criteria
in a query.
 

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

union query without "blank" recordsl 3
Filter Fields Containing Values Found in Another Table 4
Make table query: [Enter 1] AS Test 1
Delete Query Help 2
Copying Query Results into a Table 1
Group by query question 1
Only first few records visible in table after running append query 1
Duplicates in union query 3

Top