Multiple Groups
Is there a way to have multiple groups? I have a recordset with names,
dates, and account. What I would like to do is group by name, and then
group by date by name. So in a format like the following:
John Doe
01/01/2009 $100
01/02/2009 $200
Jane Doe
01/01/2009 $150
01/01/2009 $330
My recordset looks like as follows:
John Doe 01/01/2009 $50
John Doe 01/01/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $100
Jane Doe 01/01/2009 $50
Jane Doe 01/01/2009 $50
Jane Doe 01/02/2009 $300
Jane Doe 01/02/2009 $30
Any suggestions would be greatly appreciated.
-StinkyDuck
dates, and account. What I would like to do is group by name, and then
group by date by name. So in a format like the following:
John Doe
01/01/2009 $100
01/02/2009 $200
Jane Doe
01/01/2009 $150
01/01/2009 $330
My recordset looks like as follows:
John Doe 01/01/2009 $50
John Doe 01/01/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $100
Jane Doe 01/01/2009 $50
Jane Doe 01/01/2009 $50
Jane Doe 01/02/2009 $300
Jane Doe 01/02/2009 $30
Any suggestions would be greatly appreciated.
-StinkyDuck
This discussion has been closed.
Comments
main menu--add the group by the field name for the client.
HTH,
Ed Dressel
Team DM
was under the assumption that you could only have one group. Thanks!