grouping in a query

M

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
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Design Question Access 2007 2
Segregarting results of a join into two fields 3
exclude certain data in query 7
Using form to fill in query criteria not working 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
query to show where no data in a stated column 0
Show data source in Union Select All Queries 2
IN SELECT Query Criteria 9

Top