Okay--this is kind of an odd request. . .
I have a table that lists courts and the year they completed a project. So frequently a single court may have completed projects in multiple years.
Obviously, the query lists them per record as follows:
Court#1 2000
Court#1 2001
Court#1 2002
etc.
I would like it to print on the report as:
Court #1 2000/2001/2002
Is that even possible?
Just FYI--the Court is the detail of the report--there are two grouping levels above it.
I have a table that lists courts and the year they completed a project. So frequently a single court may have completed projects in multiple years.
Obviously, the query lists them per record as follows:
Court#1 2000
Court#1 2001
Court#1 2002
etc.
I would like it to print on the report as:
Court #1 2000/2001/2002
Is that even possible?
Just FYI--the Court is the detail of the report--there are two grouping levels above it.