Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 02-23-2015, 06:02 AM   #1
Newly Registered User
Join Date: Dec 2013
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
gkl is on a distinguished road
Grouping Levels

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?


Last edited by gkl; 02-23-2015 at 06:03 AM. Reason: Spelling Mistakes
gkl is offline   Reply With Quote
Old 02-23-2015, 06:13 AM   #2
Join Date: May 2011
Posts: 9,348
Thanks: 10
Thanked 2,270 Times in 2,222 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Grouping Levels

Can you demonstrate what you mean with sample data? Post what data you are starting with in your table and then what results you hope to end with in your report.
plog is offline   Reply With Quote

access 2013 , grouping , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a Report with Grouping Levels & Export to Excel noboffinme Reports 1 04-26-2010 12:05 PM
Avoiding 20 levels of Iif-Then-Else themurph2000 Queries 17 03-24-2008 05:55 AM
Sum of time (short time format) for different grouping levels. Someone123 Reports 0 11-28-2007 03:14 AM
Access levels kenshinx1 General 5 04-11-2007 01:40 AM
combining data for grouping levels Paulp Reports 1 01-24-2000 01:55 PM

All times are GMT -8. The time now is 06:56 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World