Access - grouping in reports

Resolved · High Priority · Version 2010

Thu 8 Nov 2012, 14:55 Delegate Holly said...

Holly has attended:
Access Introduction course
Access Intermediate course

Access - grouping in reports

Hello

I have set up a query to show, all the customers that have bought a certain category of product in the last 18 months. When i run the query it is correct but it lists each company over and over again for each invoice. i want it to group them, i have managed to group them in a report but then it doesnt group the products, it lists them over and over again.

Is there a line on the query that you can put grouping?

thanks

Fri 9 Nov 2012, 09:36 Trainer Simon said...

RE: access - grouping in reports

Hi Holly,

Thank you for your question and welcome to the forum.

The query is the raw data. When you create the report you can group by Company first and then by Product. Once you have done that, in Design View, move the Company field from the Details section into the Company Header section which will eliminate the repetition of the company name. Repeat the procedure above for the Product.

I hope this answers your questions.

Regards

Simon

Thu 15 Nov 2012: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips