Group via Criteria anyone?

[JethroUK©]

I want a monthly report to produce statistics for the current month -
grouped by different criteria - essentially 3 different reports in one -
e.g.

1st Group by [enrolment date]

2nd Group by [Start Date]

3rd group by [completion date]

I realise that any one record could comply with several of the criteria -
but i am producing a report of activities in the month so it's not important
which group such a record appears in

I already have a query that produces these 3 groups of records via 'or'
ing - but i cant figure out how to display these 3 distinct groups on a
report

will i have to produce three seperate reports?

 

[Marshall Barton]

I want a monthly report to produce statistics for the current month -
grouped by different criteria - essentially 3 different reports in one -
e.g.

1st Group by [enrolment date]

2nd Group by [Start Date]

3rd group by [completion date]

I realise that any one record could comply with several of the criteria -
but i am producing a report of activities in the month so it's not important
which group such a record appears in

I already have a query that produces these 3 groups of records via 'or'
ing - but i cant figure out how to display these 3 distinct groups on a
report

will i have to produce three seperate reports?

Well, you can not "group" by what is essentially criteria
unless you use three queries (which can recombined by using
UNOIN), but you will get every record in each group. It's
probably easier to use three reports as subreport's in an
unbound main report.

Maybe I could get another idea if you posted the query that
you are using.