Filter and Query Mismatch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ayo - 23 Jan 2008 00:33 GMT

When I do a filter in a table, I get 371 records but when I run a query
based on the same set of criteria I get 63 records. Does any one knows what
is going on here? This is a real problem and I can't figure out how to fix
it. Any help will be greatly appreciated.
Thanks

Reply to this Message

John W. Vinson - 23 Jan 2008 04:40 GMT

> When I do a filter in a table, I get 371 records but when I run a query
>based on the same set of criteria I get 63 records. Does any one knows what
>is going on here? This is a real problem and I can't figure out how to fix
>it. Any help will be greatly appreciated.
> Thanks

Please post the SQL of the query and describe how you're setting the filter.
Nobody here could possibly help given this information - even if you do post
it five times <g> (your software may have erroneously told you that it failed
to post, the webpage has been having problems).

John W. Vinson [MVP]

Reply to this Message