Filter on Access Page not finding all the records

[Weim]

I have a fairly simple database that I have created an Access HTML page from using the wizard.

When you open the new Access page, highlight a word and click the filter icon, it will not find all the records. There seems to be no consistancy on what it finds.

I may Filter the word "Check" and get 8 results, go to the actual table run the same filter and get all 20 results.


Just odd.


Jeff

 

[Weim]

I found out some more informtion on this,

My table contains a column which has entries such as "Check 1", "Check 2", "Check 3" for example. From the Access page, when I highlight the word "Check" in the "Check 1" entree and click the filter icon, the returns I get is for "Check 1" only

The table on the other hand, if I highlight "Check" in the "Check 1" entree and click the filter icon. The returns I get are for everything in that column that contains the work "check"

Perhaps the Access page lacks the functionality of the table when it comes down to filtering???