Grouping Question?

[Guest]

Hello!

I have a query and report for student schedules. I want to show the
student's 'day' next to each other. Below is what I have now and what I want.

[Current Report Format]


Last Name, First Name
_____________________
Course Section Tchr. Room
Period Day

English 8 01 Mr. X 100
5 1
English 8 01 Mr. X 100
5 2


[Desired Report Format]

Last Name, First Name
_____________________
Course Section Tchr. Room
Period Day

English 8 01 Mr. X 100
5 1,2

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

Perfect...thanks!

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
Duane Hookom
MS Access MVP

Hello!

I have a query and report for student schedules. I want to show the
student's 'day' next to each other. Below is what I have now and what I
want.

[Current Report Format]


Last Name, First Name
_____________________
Course Section Tchr. Room
Period Day

English 8 01 Mr. X 100
5 1
English 8 01 Mr. X 100
5 2


[Desired Report Format]

Last Name, First Name
_____________________
Course Section Tchr. Room
Period Day

English 8 01 Mr. X 100
5 1,2