How Do I? (1 Viewer)

[Matty130788]

Hi

I've put promts into my query criteria so that the user has to enter what criteria they would like, however I need one of the promts to be optional but I can't figure out how I can get the prompt to accept a blank field if you don't want to put a criteria in.

Any ideas

Thanks

Matt

 

[iangirven]

Try somethng like the following in the criteria section of the field you want to prompt.
like "*" & [Enter data prompt here] & "*"

The bit between the [ ] will be displayed in a prompt so if you want it to ask for a name you would have [ Please Enter name] or whatever you want the prompt to be.

If nothing is entered then all the records will be returned for that query.

this may not be what your looking for but hopefully will get you on the right track.

good luck

Ian

 

[Matty130788]

Works Exactly the way I want it to

Thanks Alot