lcline
10-23-2001, 05:55 PM
Hello,
Please help this newbe create a query whose form passes three values from
dropdown menus to create a report. I have it set up where is works when all
criteria is straight forward (dropdown 1 = specific, dropdown 2 = specific,
dropdown 3 = specific). What I need is the dropdown 3 pass "specific 1" OR
"specific 2" so that all records that fit dropdown 1 & 2 AND dropdown 3's OR
statement to include specific 1 & specific 2. Any help or direction would
greatly be appreciated. (remember, I have only been (access) at this for 1
week)
Lee
Please help this newbe create a query whose form passes three values from
dropdown menus to create a report. I have it set up where is works when all
criteria is straight forward (dropdown 1 = specific, dropdown 2 = specific,
dropdown 3 = specific). What I need is the dropdown 3 pass "specific 1" OR
"specific 2" so that all records that fit dropdown 1 & 2 AND dropdown 3's OR
statement to include specific 1 & specific 2. Any help or direction would
greatly be appreciated. (remember, I have only been (access) at this for 1
week)
Lee