98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - grouping in reports
Access - grouping in reports
Resolved · High Priority · Version 2010
Thu 8 Nov 2012, 14:55Delegate 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:36Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hiding Multiple Table columnsIf you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide. |
