On Wed, 17 Mar 2010 05:44:01 -0700, Glenn
wrote:

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

I'm sorry, but this query makes no sort of sense.

You're telling Access to group by a value *which isn't even in the table* - a
value entered on a form.

I'm *guessing* (knowing absolutely nothing about either your table or what
you're trying to do) that the Forms![Select Agent]![Select Agent] should be on
the criteria line under the Agent field, rather than in the Fields row of the
grid... but a clearer explanation of your table structure and goal would
certainly help.

Note also that what you are posting is NOT a Macro but a Query. Different
beast entirely.

--

John W. Vinson [MVP]