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
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
