Hello,

I have a query like this:

ID Date Email

2 5/19/2011 1@aol.com
2 5/19/2011 2@aol.com
3 5/19/2011 3@aol.com
4 5/19/2011 4@aol.com
4 5/19/2011 5@aol.com

How do I select the combined email(s) with any record that is the same ID and Date.

I tried this:

Select ID, Date, Email
From qryName
Group by ID, Date, Email

I does not work.

The output I like to see is:

ID Date Email
2 5/19/2011 1@aol.com; 2@aol.com
3 5/19/2011 3@aol.com
4 5/19/2011 4@aol.com; 5@aol.com


Thanks very much.