If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Query
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 |
Thread Tools | |
Display Modes | |
|
|