GROUP BY Question (1 Viewer)

[betheball]

This may be mnore of a ASP question, but I am not sure. In a db that is for reserving campsites, there are frequently 10-12 records where the value for every field is the same except for the campsite number, ie, the reserving person's name, the date, email address are the same for each record. I am struggling to find a way to output just one instance of the fields that are the same with a list of all campsites reserved for the date(s) in question. For example, I may have 5 records that look like this:

Name Date CampsiteNumber
Fred 8/1/2005 1
Fred 8/1/2005 7
Fred 8/1/2005 32
Fred 8/1/2005 33
Fred 8/1/2005 34

I would like to output to a web page something like:

Name Date Campsite #s
Fred 8/1/2005 1, 7, 32, 33, 34

Any thoughts on this? I think I have done this before, but cannot remember what I did.

 

[Pat Hartman]

This article shows the technique.

http://support.microsoft.com/default.aspx?scid=kb;en-us;141624