I have a query which I need a bit of help with.

I have written the query as follows:-

Coloumn 1
Field: Expr1:[forms]![Select Agent]![Select Agent]
Total: Group By

Coloumn 2
Field: CL Code
Table: Contracts Entered Data
Total: Group By

The macro look at a form Select Agent and takes the name choosen from a drop
down menu (CL Code) on that form. I want the next stage of the macro to only
select records where the CL Code is the same as what was choosen in stage 1

Thanks