• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1123
  • Last Modified:

Group multiple records from query results in MS Access

Hi Experts

I have a query which brings together a list of participants who have attended either single/multiple events on different dates.

I need to group each [Event Date] and [Venue] and list next to each the [Centre Name] and [Participants] who attended the event.

I have attached an example which may help explain what I am needing.

Any assistance would be appreciated.

Thanks
darls15
Example-31032014.xlsx
0
darls15
Asked:
darls15
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can do this easily with a report with the "1st Query Results" dataset:

Create a report that is grouped on EventDate. Include in the Group header the information for Venue, Center Code and Center Name.

In the Detail section you'd include the Participant field, along with any other fields that need to be shown "per participant".

You might also need to set "Hide Duplicates" to Yes in the group's properties.

If you're trying to do this as a query, I'm not sure how (or why) you'd do it.
0
 
hnasrCommented:
In the report, group on  [Event Date] then [Venue]
In detail section add required fields.
Set properties not to repeat fields.
0
 
darls15Author Commented:
I don't do a lot with reports and wasn't even considering one as a solution. I've managed to create the output I need. Thank you both for your assistance.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now