Open Tables
Go to Records/Filter/Advance,Filter,Sor
Drag the fields you want to see down to the fields row. You will only see the data from the fields you drag down
Or: If the field are all in there already on the filter design then just put the criteria in the field you want to filter
In the criteria cell: Type A or B
Or... what ever you want to filter from the field but you can only type one strin
at a time or you have to use the nest row down and so o
If you want to see everything but A Type NOT "A
If you want to find blank cells then type: nul
Then look down the bottom of your the window where acces tels you how many records were filtered
You can do a similar thing using query design.