tbartow
03-01-2002, 12:55 PM
Hi all!
I have designed a database which pulls 30 days worth of data at a time from numerous queries that answer specific things into a union query. I then send the union query to Excel to build time-series graphs.
Each month I make a copy of the DB, change all the column headings, and plug in the new data for the month. As you can imagine, this is getting tedious.
I want to change the design somehow to put the data for all months into one spot (one table). I have no user interface yet, but I'd like to build a selection screen which allows the user to be able to specify what range of dates to pull from the queries(ex- 2 weeks instead of a month). BTW, The days are all in a julian (number) format. Any suggestions?
I have designed a database which pulls 30 days worth of data at a time from numerous queries that answer specific things into a union query. I then send the union query to Excel to build time-series graphs.
Each month I make a copy of the DB, change all the column headings, and plug in the new data for the month. As you can imagine, this is getting tedious.
I want to change the design somehow to put the data for all months into one spot (one table). I have no user interface yet, but I'd like to build a selection screen which allows the user to be able to specify what range of dates to pull from the queries(ex- 2 weeks instead of a month). BTW, The days are all in a julian (number) format. Any suggestions?