Group by ID number - If statement ....

[learning_codes]

Hi,

I have couples of players have many schedules and home address. I'm
trying to group one line with many schedules.

For example:

I ran the query and it look like this:

ID Player Name Date Room Home Address
23 John Smith Apr 3 A 12 Expressway
Road
23 John Smith Apr 5 A 12 Expressway
Road
23 John Smith Apr 10 A 12 Expressway
Road


Is there a way to ran the query like this by using If statement.....?:

ID Player Name Date Room Home Address
23 John Smith Apr 3 A 12 Expressway
Road
Apr 5
Apr 10

Your help would much appreciated.

Thanks

 

[Guest]

There is a generic concatenate function that might work for you at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.