applying a filter, to show X results in another table?

[scottee1988]

i have a database with about 2000 records in, i want to be able to

ctrl + F, Find what? Find "PE"

instead of flicking through each PE wherever it comes, can i get it to filter out all the PEs and show them on a seperate table? thanks

 

[dhookom]

That's kinda like what queries do. You can right click in a field and enter *PE* in the search box. This will create a filter on your table for records containing PE in the field.

Duane
Hook'D on Access
MS Access MVP