G
Guest
Within my database, I have a qry that takes in several tables, including junctions. These are the ones that are involved in the question (only including fields in question).
Table: Employee; Fields: Initials (PK), Last Name, First Name
Table: Events; Fields: ID (PK), MNE, Event Name, Event Date, Start Time, End Time
Junction Table: EmployeeEvent; Fields: Initials (from Employee Table), ID (from Events table)
The purpose for the junction is to avoid (or create?) the many-to-many relationship. Several employees can participate in multiple events and each event will have more than one employee participating.
I have my qry giving me all of the data. It gives me a record for each occurance of each event for each employee. Hence, I have 42 events with two employees per event, or 84 records. With me? Am I making sense?
My question is.... in the report (and I'm also going to want to make labels like this), I want it to list each event like this...
Date Event Name
Start time "to" End Time
Employee 1
Employee 2
Right now when I try to do a report, it lists a separate line item per record on the qry. So instead of the 42 events listing the two employees participating, I get 84 separate listings.
How can I get it to report with all the Employees showing up for that Event on that date?
Where can I make changes / improvements and who can I get it to behave the way I'm wanting????? This will also come into play when I add that there will be materials that will be used at each event (more than one material per event).
Have a great weekend and I'll get the answer on monday! Thanks much!!!!!!
Table: Employee; Fields: Initials (PK), Last Name, First Name
Table: Events; Fields: ID (PK), MNE, Event Name, Event Date, Start Time, End Time
Junction Table: EmployeeEvent; Fields: Initials (from Employee Table), ID (from Events table)
The purpose for the junction is to avoid (or create?) the many-to-many relationship. Several employees can participate in multiple events and each event will have more than one employee participating.
I have my qry giving me all of the data. It gives me a record for each occurance of each event for each employee. Hence, I have 42 events with two employees per event, or 84 records. With me? Am I making sense?
My question is.... in the report (and I'm also going to want to make labels like this), I want it to list each event like this...
Date Event Name
Start time "to" End Time
Employee 1
Employee 2
Right now when I try to do a report, it lists a separate line item per record on the qry. So instead of the 42 events listing the two employees participating, I get 84 separate listings.
How can I get it to report with all the Employees showing up for that Event on that date?
Where can I make changes / improvements and who can I get it to behave the way I'm wanting????? This will also come into play when I add that there will be materials that will be used at each event (more than one material per event).
Have a great weekend and I'll get the answer on monday! Thanks much!!!!!!