What is the wildcard?

[bmwccn]

I`ve got a report which opens with a query, so i can choose which records to be shown in the report. If I want them all to be shown what can I type in the query field?

 

[RichO]

If you are referring to a parmeter query, the wildcard * will only work if the criteria uses the word "Like".

Try typing * and if it doesn't return any records you may want to add "Like" to the criteria, ie:

Like [Enter Search Data]

 

[cogent1]

If it is a parameter query, use the following expression:


Like "*" & [your parameter] & "*"

If the parameter is left blank, all records will be returned.