Writing a Group-by Query into a Variable

[VLG711]

Hi,
I have a DB that has a form with a timer. Once an hour this Form executes code that does some dlookups and writes the values to a HTML sheet. My issue is that I would also like to include all columns and rows of a group-by query. I don't know the best method for getting all of the data into my variable/variables. All of the commands I've seem so far only pull one value from one field.

If I've not explained myself very well please let me know.

Any help is greatly appreciated,

VLG711

 

[PHV]

One way is to play with a Recordset (either DAO or ADODB).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886