Multiple criteria query by form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know if what I'm trying to do is possible, but here goes. I want to
display a report based on a query which gets its parameters from a form,
using a combination of option groups and combo boxes. I want to be able to
filter data by store, area, date ranges, and status. I also want to have ALL
choices, ie., all the records, all stores, all dates, etc.. These will
necessarily return NULL values to the query, which naturally is expecting
something. In developing the query and starting to add parameters from the
form, I used the clear, concise example by PC Datasheet (thank you very much
by the way!), adding

Forms!MyForm!NameOfDropDownBox Or (Forms!MyForm!NameOfDropDownBox Is Null)

which worked well, until I added a second parameter. So, is what I'm trying
to do possible, and, if so, I'd appreciate being pointed in the right
direction.

Thanks guys.
 
I don't know if what I'm trying to do is possible, but here goes. I want to
display a report based on a query which gets its parameters from a form,
using a combination of option groups and combo boxes. I want to be able to
filter data by store, area, date ranges, and status. I also want to have ALL
choices, ie., all the records, all stores, all dates, etc.. These will
necessarily return NULL values to the query, which naturally is expecting
something. In developing the query and starting to add parameters from the
form, I used the clear, concise example by PC Datasheet (thank you very much
by the way!), adding

Forms!MyForm!NameOfDropDownBox Or (Forms!MyForm!NameOfDropDownBox Is Null)

which worked well, until I added a second parameter. So, is what I'm trying
to do possible, and, if so, I'd appreciate being pointed in the right
direction.
Click to expand...


When you want help with a query, you should post a
Copy/Paste of the query's SQL view so we can see what you
are working with.

That kind of criteria does what I expect it to do. What is
it doing that you don't like?
 
Back
Top