G
Guest
I am using Access 2002 and created an unbound form with a couple fields to be
used for search criteria to be selected on the fly to drive a query. I have
a field called Region and one called Status. I entered the form fields in
the query criteria but can only get the results to work using one selection
criteria at a time. How can I make the query run if both selection criteria
have a value selected from it?
For example, if I select "active" from the status drop-down field on the
form, the query runs correctly. But if I select "active" from the status
field and "2" from the Region field - the results are inaccurate.
Here is what I have in the query criteria: Under the Region field -
[Forms]![frm_rpt_test]![Region_Code] and under the Status field -
[Forms]![frm_rpt_test]![Status_Code]. I know I am not finding the right
combination or rows to place this data in the query design. Thanks!
used for search criteria to be selected on the fly to drive a query. I have
a field called Region and one called Status. I entered the form fields in
the query criteria but can only get the results to work using one selection
criteria at a time. How can I make the query run if both selection criteria
have a value selected from it?
For example, if I select "active" from the status drop-down field on the
form, the query runs correctly. But if I select "active" from the status
field and "2" from the Region field - the results are inaccurate.
Here is what I have in the query criteria: Under the Region field -
[Forms]![frm_rpt_test]![Region_Code] and under the Status field -
[Forms]![frm_rpt_test]![Status_Code]. I know I am not finding the right
combination or rows to place this data in the query design. Thanks!