I am tryting to run a qry based on resrtictors in a from. Is it possible to
set it up so that the from has several option to restrict the data but at the
same time I can leave soem of those restrictors blank so they do not effect
the qry? In other words my qry includes dates and course names. I would like
to run the report for a certin course but to not care about the date and visa
vera. Thank you in advance

Are you saying that your query is using controls (text boxes, combo boxes,
etc.) on the form as parameters. so that you've got something like
Forms!MyForm!MyControl as the criteria in your query grid?

Change that to (= Forms!MyForm!MyControl) Or (Forms!MyForm!MyControl Is
Null)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jason" <(E-Mail Removed)> wrote in message
news:813B6826-B55D-4B2C-ABF9-(E-Mail Removed)...
>I am tryting to run a qry based on resrtictors in a from. Is it possible to
> set it up so that the from has several option to restrict the data but at
> the
> same time I can leave soem of those restrictors blank so they do not
> effect
> the qry? In other words my qry includes dates and course names. I would
> like
> to run the report for a certin course but to not care about the date and
> visa
> vera. Thank you in advance