Filter Criteria - Select one customer or all

[sales@scantechintl.com]

Hello,

I would like to have a query where I could select just one customer or, by hitting enter, select all.

For example, [Enter Customer ID or Hit Enter to display all customers]

 

[EMP]

You can put the criteria for the CustomerID field in a new column in the query grid like this:-

--------------------------------
Field: [CustomerID]=[Enter Customer ID or Hit Enter to display all customers] Or [Enter Customer ID or Hit Enter to display all customers] Is Null

Show: uncheck

Criteria: True
--------------------------------

which is adapted from Jon K's thread in the sample database forum:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^