Query criteria to pick a store or all stores?

[afs24]

I want to my users to be able to pick a specific store in my store feild criteria or be able to pick all stores. What should the criteria in my query look like for feild store? This what I'm trying...

[Enter Store or *] or Like "*"

 

[Joe4]

I do this a lot by creating a form where they select the criteria, and based on that, VBA code runs behind the scenes that builds the query using SQL.

Creating the SQL language is not that hard, because if you build the query in Access and then select "SQL view", it shows you what the final code should look like. However, if you are not experienced in VBA code and you want to pursue this option, you may want to pick up a good book on Access VBA. It will open up a world of possibilities for your database.

 

[CT Witter]

Have a look at MS KB Article: 103181- Showing All Records (Including Null) in a Parameter Query

http://support.microsoft.com/default.aspx?scid=kb;[LN];103181

HTH,
CT