grouping in a query

[Martin Hopkins]

Hello,

I need to run a report that brings up only the records for managers at work.

They are flagged as managers in the table Name.

What I want to do is have an input form where you can select a surname or
dept and if you want only managers, without having to run the report for
each manager.

the names / dept are eay with a drop down combo box and you selct your
search which is linked to the query behing the reprt eg
forms![name]![surname]

But I cannot figure a way of just selecting manager.

any help greatly appreciated

 

[Duane Hookom]

Is there a field in your report's record source that stores whether or not a
record is a manager or not? What is the type of field? How do you use
surname or dept and why can't you use the same method?