wildcard in query criteria

[matpj]

I have a query in Access that prompts the user for criteria values in 2 fields.
If I wanted to command Access to return all results, how can I do this.
I have tried puting * and % in the criteria pop-up box, but this doesn't seem to work.

I'm trying to create this so that I can access the query in Excel and one of the users just needs to open the spreadsheet, tell it the correct vales (or wildcard for all) and thats it!

any idea?

 

[mordja]

matpj,

Make sure that in the criteria of your query design you do

like [criteria]


Now when you use * you will recieve all records.

Mordja

 

[matpj]

thanks for that.
i have another problem now.

I created the query in Access, so that when I run it in access it prompts me for the two parameters.

now when I run the database query through excel, it displays an error saying "two few parameters. 2 expected"
I have tried entering the same criteria in the query selection process, but that doesn't remove the error.

can you suggest why this is?