Grouping by department

[Public]

Hi,
I want to generate a report that contains several field from 5 different
tables and I want the result to be displayed by each department (department
is a filed in one of my tables). I have tried using Group By in my query but
I think it can only be used with aggregate functions.
Any ideas how to generate my report that have the same fields but reported
for each department?

Regards

 

[Rick Brandt]

Hi,
I want to generate a report that contains several field from 5
different tables and I want the result to be displayed by each
department (department is a filed in one of my tables). I have tried
using Group By in my query but I think it can only be used with
aggregate functions.
Any ideas how to generate my report that have the same fields but
reported for each department?

Regards

Do the grouping in the report, not the query. Use the Grouping and Sorting
form while in design view of the report.