Parameter Forms

[fordy]

Is it possible to leave a field in a parametr form blank, and it will still run query.

For example, if I have three fields on a parameter form, stock take nummber, shop area and stock takers surname. Supposing the user only wants to extract information on stock take number and area and is not bothered about name. Is this possible or do I need to build a selection of queries, thanks

 

[scottfarcus]

fordy,

if you want to email me at access_junkie@hotmail.com, I will reply with a sample of what you are trying to do.

Scott