filter returns incomplete set

[Rob James]

Hi,

When I apply a filter to my database, it frequently
returns an incomplete set. I can verify this by using
Find and clicking through the database and counting how
many records should have been filtered.

What am I doing wrong?

Thanks in advance

Rob

 

[Rob James]

Allen,

Thanks for your complete list of ideas. Unfortunately I
don't believe any of them address my issue. Ahhhh!!!

The main thing I'm noticing is that if I highlight toyota
in my table and click the Filter By Selection buttom, only
20 records get filtered. However, if I either run a query
such as Like "*toyota*" on the same field or do a find, I
get 23 records. Nothing seems to be mispelled, etc. The
field isn't indexed.

But I'm not sure what Service Pack is the latest for
Access 2k, so don't know if that's up to date.

Go figure, huh? rj

 

[Allen Browne]

Access 2000 is up to SP3.

The original (no SP) version had these kinds of bugs, particularly if the
data contained hyphens.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Allen,

Thanks for your complete list of ideas. Unfortunately I
don't believe any of them address my issue. Ahhhh!!!

The main thing I'm noticing is that if I highlight toyota
in my table and click the Filter By Selection buttom, only
20 records get filtered. However, if I either run a query
such as Like "*toyota*" on the same field or do a find, I
get 23 records. Nothing seems to be mispelled, etc. The
field isn't indexed.

But I'm not sure what Service Pack is the latest for
Access 2k, so don't know if that's up to date.

Go figure, huh? rj