Easy Parameter Query Q

[696796]

Hi,

is it possible to build a query so that a user can choose a few parameters in order to see the results, and be able to skip one of the parameters and move to the next one.

For example:-

If the parameters were to choose between two dates, and choose an area, could one of these parameters (say choosing an area) be skipped?

I know how to build normal partameter queries, but can choices be bypassed??

Thanks in advance for any assistance,

regards,

Alex

 

[SQLScholar]

Dont hold me to this but say when you do the query where you would normally have

[Please insert date] or similar

if you put

"*"&[please instert date]&"*"

That will do a wildcard at the beginning and/or end (you could remove one/other. Then if someone enters blank, it will still search on everything.

As i say i am no expert - but it may work?

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[dhookom]

You can bypass a parameter by using something like:
Where [Area] = Nz([Enter Area], [Area])
This will work for all except records where Area is null. If you have null values, then change your query to:
Where [Area] & "" = Nz([Enter Area], [Area] & "")


Duane
MS Access MVP
Find out how to get great answers faq219-2884.