I trying to develop an event tracker.
In the events table I have:
[Events].[PKEvents] as Autonumber
[Events].[EventName] as Text
[Events].[StartDate] as Date
[EndDate] as Date.
I then have a related table, where I store a many-to-many link to a personnel table.
[MMEventtoPersonnel].[PKMMEventtoPersonnel] as Autonumber
[MMEventtoPersonnel].[FKEvents] as Number
[MMEventtoPersonnel].[FKPersonnel] as Number (Dual Primary key on FKEvents and FKPeronnel.)
So that for one event, I might have 5 people assigned and for another I might have 10.
Eventually, I have to provide a percentage of available manning for each day, by section, but before that I have to figure out how to list the inclusive dates between the start and end. I have searched, but don't think I am asking the question right. So I have the basic table (which I created from a query) in the attached db, I also included a spreadsheet for how I envision the output to appear in an actual query.
Eventually, everything will be passed to the query from a form parameter, so that it continues to be dynamic.
Any thoughts?