Inclusive dates for event

[jon6035]

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?

[June7]

Wasn't this resolved with thread https://www.accessforums.net/queries...rim-17497.html

You want to input a start and end date and return event records where the event starts and ends within the given dates? Try:
SELECT Event, [Personnel Name], StartDate, EndDate, [Input start date] AS Start, [Input end date] AS [End]
FROM Events
WHERE ((([Input start date])<=[StartDate]) AND (([Input end date])>=[EndDate]));

[jon6035]

It is solved. But not by the other thread. I needed to reset start and end dates dynamically, without user input for both values, and without them being able to choose more than 33 days. I built a bunch of sub queries to get it done.

Thanks for your help again.

But I will definitely use your syntax below.