Filter expressions 1

[jannecum]

Where can I find examples of expressions to use in the "filter for" operation in a form view or datasheet view in MS Access? specifically I want to filter for all "TF" and all "BR" in a field called type.

 

[lameid]

The easy thing to do is make a query that filters its records and then switch to the SQL view. Everything in the where clause (except for the word where) is good example criteria.

The simpliest queries have three clauses and below is an oversimplification which I think suits your purpose otherwise.

Oversimplified SQL:

Select <Field list spearated by commas>
From <Tables and or Queries>
Where <Criteria>

 

[jannecum]

Lameid,
Thank you for sharing that method. I was able figure the proper criteria after looking at a query in SQL view. I will remember this for future use also - thank you.