Dear All,
I have a query in Access 2013 that generates four fields, first name, last name, department and equipment and I want to produce a report that groups by department, then first and last name and then equipment.
I know I can have the query generate the full name by concatenating first and last name and then use that in the report but ideally I would like something like the following: when using the Report Wizard to produce the report and when getting to Grouping to be able to move Department first as grouping, then first name, then last name and then merge first name and last name into the same grouping level.
Could that be done or is there a way different than the one I mentioned before (modifying the query) to achieve this?
Regards,
George
I have a query in Access 2013 that generates four fields, first name, last name, department and equipment and I want to produce a report that groups by department, then first and last name and then equipment.
I know I can have the query generate the full name by concatenating first and last name and then use that in the report but ideally I would like something like the following: when using the Report Wizard to produce the report and when getting to Grouping to be able to move Department first as grouping, then first name, then last name and then merge first name and last name into the same grouping level.
Could that be done or is there a way different than the one I mentioned before (modifying the query) to achieve this?
Regards,
George
Last edited: