Take a look at Richard's video Next Business Day and look at his links and Code

Also Richard's video https://www.599cd.com/blog/display-article.asp?ID=2425

Hi John. Thank you for your response. I re-watched those videos, including the Extended Cut video of the Next Business Day video. Unfortunately that's not what I'm looking for. I'm looking to generate a list of dates not based off of any table, but only based off of the start date and end date of entered parameters. I forgot to mention the fact they are entered parameters in my original question. Ultimately the dates will be based off of something, but for now they're manually entered.

I do already have a query that takes the dates I have in a table and converts them to the start date of the week so I can run them through an aggregate query and sum up the event hours for that week. What I'm trying to accomplish is adding in those weeks where I don't have any events.

I've thought about using VBA and temporary tables, which I could do, but I was trying to see if I could do it through queries first, since I already have those built and would hopefully be simpler.

Hi Michael, you need a table to make that list.  Even if you make a query, you still need a table, because a query can't create records on its own.  A query needs a table to have multiple rows, such as in SELECT Field1 FROM Table1 -- if Table1 has N rows, that's how many rows the query has.  If you just write SELECT "something" As Field1, this query can only have one row.

You can make a table with a list of dates you want by manually entering them if there are not too many, or using VBA to populate the table with a starting date on a Monday, then subsequent dates that are 7 greater than the previous one.

Hi Kevin. Yeah, that's kinda what I was thinking. I figured I'd ask in case there was something that could calculate that list just with SQL that I wasn't aware of, but I may have to go with VBA to calculate the dates and populate a table with those dates when asked for the range.

It's something I COULD put in a table manually since it wouldn't take me that long for each year, but I'm trying to keep as many aspects automated/calculated as possible for this project.

Thanks!

I ended up creating a table and wrote VBA code to wipe the table, then insert in the weeks specified using a While loop and SQL.