Selection criteria for a report

[Martin Hopkins]

Hello,

I have several reports that are configured to run with the input parameter
set by the user in his selection via a form.

The user selects either a Dept, or a trade or an office. The report output
relates to the selection by means of an input criteria in the underlying
query on the report.

I have 3 lines of crieria:

1. Dept = forms!dept
or
2. trade = frorms!trade
or
3. office = forms!office

all runs well with only 1 criteria chosen,

But if i want ot run a report for say Manufacturer Dept and Welders, then I
get all the dept Manufacturer returned as well as the welders.

How do I select a dept and only Welders.? Can I use an Group Option? Or do I
cange the underlying query?

Any help greatly appreciated.

Martin Hopkins

 

[Duane Hookom]

It sounds like you want "And" rather than "Or" in your query.