Possible VBA on a report?

[lawsonium]

Am in a rush, sorry.

Have a report grouped by Course then Month. It then lists dates of courses in Acending order for a given course in a given month.

I would like to alter the output for the first date so it lists subsequent dates one oafter the other.

i.e.

If Course 1234 session = 1 then show all subsequent sessions

Like this:

Course 1234 Session 1 Date 01/07/07
Session 2 Date 02/07/07
Session 3 Date 02/07/07
and so on.

The trouble is, I still want the following months to be grouped and show the continuing session. So basically I don't want to alter the grouping.

Sory this is quick.

Thanks,

Matt.

 

[boblarson]

So you want Course 1234 to show up once in the list. Now I can't help you with moving the other data, to the left under Course 1234, but if you can live with it like:

Course 1234 Session 1 Date 01/07/07
            Session 2 Date 02/07/07
            Session 3 Date 02/07/07
and so on.

Then you just have to set the HIDE DUPLICATES property for the text box to YES.