Grouping Question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Perfect...thanks!

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

--
Duane Hookom
MS Access MVP


Emma Doginson said:
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
Click to expand...
Click to expand...
 
Back
Top