Query Critera to Show all Numbers

[Cullihall]

Hey guys.

I normally filter text fields in queries using combo boxes on forms to show all records. So I set the default combo box value to "*" and use query criteria Like FORMS!MyForm!MyCombo

How can I achieve this for numeric fields in a query? I want to have an option in my combo box that the user can select and it will display all records in the query. The * only works with strings.

 

[pbaldy]

One way:

http://www.mvps.org/access/queries/qry0001.htm

 

[Cullihall]

One way:

http://www.mvps.org/access/queries/qry0001.htm

Thank you pbaldy!

 

[pbaldy]

No problemo!