Hello all,
I have a database I'm working. In this data base I have 3 tables, tblPeople, tblEvents, and tblPeopleAtEvents.
I have most of my reports working kinda how I want them.... I need 1 of them to work a little different.
My overall goal, is to display events, (count these events), count the types of events(I have 2 types of events... saved in the tblEvents as EventType), and display the events, Count the miles traveled(saved in tblEvents) and hours spent(saved in tblEvents).
The problem is, in the tblPeople, I have several different... groups for each person. Think of them as which office they work in. These are called, flight (like military flights) in my database.
So billy bob might be in Alpha flight, and jessica might be in Bravo flight... and so on.
My goal is to display what I mentioned above, but by flights only not by the actual people... then I want to NOT display duplicate events. Because if billy and jessica both went to the same event... then i don't want it counted 2 times.
My problem is, i don't know how to do this.
I am able to list it out by people(grouped by flight) but if 3 people were on the event, it list it 3 times. ... Not only do I not want it to count it 3 times, I don't want it displayed 3 times...just once.
Any ideas out there?
I was thinking some type of qry, with an if eventID = (already used) then skip to next record... kinda thing?
Any help would be appreciated... Thanks.
I have a database I'm working. In this data base I have 3 tables, tblPeople, tblEvents, and tblPeopleAtEvents.
I have most of my reports working kinda how I want them.... I need 1 of them to work a little different.
My overall goal, is to display events, (count these events), count the types of events(I have 2 types of events... saved in the tblEvents as EventType), and display the events, Count the miles traveled(saved in tblEvents) and hours spent(saved in tblEvents).
The problem is, in the tblPeople, I have several different... groups for each person. Think of them as which office they work in. These are called, flight (like military flights) in my database.
So billy bob might be in Alpha flight, and jessica might be in Bravo flight... and so on.
My goal is to display what I mentioned above, but by flights only not by the actual people... then I want to NOT display duplicate events. Because if billy and jessica both went to the same event... then i don't want it counted 2 times.
My problem is, i don't know how to do this.
I am able to list it out by people(grouped by flight) but if 3 people were on the event, it list it 3 times. ... Not only do I not want it to count it 3 times, I don't want it displayed 3 times...just once.
Any ideas out there?
I was thinking some type of qry, with an if eventID = (already used) then skip to next record... kinda thing?
Any help would be appreciated... Thanks.
