Hello,

I am trying to populate a table with every date for the last 120 days. For example, given that today is 4/17/09, I want:

4/17/09
4/16/09
4/15/09
4/14/09
...
12/21/08
12/20/08
12/19/08
12/18/08

Is this possible without setting up a "dates" table? I've set one up with the other data I need for this table for the next two years, but it dramatically increases the size of my DB. I would rather have it calculate as needed and then I don't have to worry about having to change the table again at some point in the future.

Thanks!

Welcome to UA.

What is it you are trying to do and we might be able to offer a solution.

Jim

I work for a retail store. I am trying to combine order data from one system with sales data from another system for specific days. The only way I could figure out how to do this (and it very well may not be the best way), was to create a "template" file with every store, item, and transaction date with "Qty Ordered" and "Qty Sold" set to zero.

I use a make table query to select the date range I need and update queries to populate the appropriate number in the appropriate place in the template from each of the two data sets. This was the only way I could ensure that no data was lost between the two as there isn't always overlapping data for every day for every item and I wasn't getting all of the data all of the time.

The template table I had to populate with the dates has all 97 stores with the 120 items I am tracking for every day for the next year and it has almost four million records.

I would welcome any suggestions you may have. Thank you.