need help with query ...

[bcap]

Hi,

I am looking to write a query with multiple factors and do not know
the best way to do it.

I want use Event Type, Status, and Region as my queries variables. By
default I want show "all", but then be able to use drop downs to
filter with.

Can anyone please give me an idea on the best way to do this? If this
does not seem to make sense, please let me know.

Kind Regards,
Ray

 

[Douglas J. Steele]

To be able to have combo boxes for query parameters, you must create a form
with an unbound combo box for each parameter.

See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web" for how
to add the keyword "All" to each combo box.

In your query, set your parameters to

Forms![NameOfForm]![NameOfCombo] Or (Forms![NameOfForm]![NameOfCombo] =
"All")

Put a command button on your form to invoke the query.

 

[bcap]

Hi,

I am actually using an Access DB with an ASPClassic front-end, would
this stay the same?

Thank you very much! =)

 

[bcap]

Hi,

I just tried out this sample. I think I need to explain my idea
better.

I have a field of event types, regions, and status.

By default, I would everything to show.

What I would like to do is give the users the ability to be able to
query for a specific event in a specific region. Or maybe simply all
event types and all regions with a pending status.

Basically, I want to create a query depending on the different
combinations of these variables.

Is this possible? My biggest concern is, what happens if one of these
fields is null?

Thank you,
Ray