filter a table

[yogi]

what is the best way to filter a table?

 

[tehNellie]

With a SELECT query using the WHERE clause.

 

[yogi]

can you explain to me how does the select work in access?

 

[tehNellie]

I'd suggest that you search Access help for "query" or "query;select"

But in short, Tables in Access hold your data, you use Queries to view or modify your data. a SELECT query is just that, you SELECT data from your table that you wish to view.

Have a read of the help screens for designing a query and types of query in Access, these will help you get up and running getting the date that you want out of your tables.

Sorry if this sounds like a bit of a cop out, but the basic information that you need is already in Access.

 

[yogi]

i know how a query work in other software, but in access i'm new at it. so I did try and it work find. thanks for all your help.

 

[Fernando]

If you are viewing your table in datasheet view, you can select from the menu: Records -> Filter -> Filter by Form
There you can write the criteria on the field you like.
Let's say u have a customers table, and you want to see the records where the CustomerID field is greater than 5, then you go to the customerID filed and write:
> 5
After this rightclick and select Apply Filter/Sort