samonwalkabout
Registered User.
- Local time
- Today, 11:35
- Joined
- Mar 14, 2003
- Messages
- 185
I Have 3 tables
tblEvents
-eventID
-eventName
-EventDate
tblTrim
-TrimID
-Name
Tblschedule
-ScheduleID
-EventID
-TrimID
Tblschedule is basically a many-to-many link table showing which names are going to which events. I want to create a qry that Looks at the date of events and tells me if any names are booked on more than one event in a day.
I cant think how to get it to do this to the entire record set at once, just on name at a time or one event at a time. What i need is too see any conflicts for all.
Im guessing is a few querys that build on each other
Any Ideas
Can post sample DB if needed
Thanks
tblEvents
-eventID
-eventName
-EventDate
tblTrim
-TrimID
-Name
Tblschedule
-ScheduleID
-EventID
-TrimID
Tblschedule is basically a many-to-many link table showing which names are going to which events. I want to create a qry that Looks at the date of events and tells me if any names are booked on more than one event in a day.
I cant think how to get it to do this to the entire record set at once, just on name at a time or one event at a time. What i need is too see any conflicts for all.
Im guessing is a few querys that build on each other
Any Ideas
Can post sample DB if needed
Thanks