Grouping by department

  • Thread starter Thread starter Public
  • Start date Start date
P

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
 
Public said:
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
Click to expand...

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