Repeated information

[Guest]

Doing student schedules for 'odd' and 'even' days.

Report shows:

Course Tchr Name Room Period Day
161-01 Smith, A. 163 1 1
161-01 Smith, A. 163 1 2
078-02 Rogers, D. Gym 2 1
077-05 Clunk, D Art 2 2


Want it to show:

Course Tchr Name Room Period Day
161-01 Smith, A. 163 1 1 2
078-02 Rogers, D. Gym 2 1
077-05 Clunk, D Art 2 2

 

[Duane Hookom]

You can use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. The
download includes the function and sample usage.