Rolling Report - auto generate field population?

[NKA]

I currently have a sick report that reports on 13 months of data. The information is provided to me monthly in Excel, which I import into Access and append records to existing table.

I then modify the report each month to drop oldest month, include newest month and re-total the total column.

I would like to somehow be able to just link the Excel spreadsheet once (and have HR update this in a give file location on the server) and then have a report that will include the new month, drop the old month and recalculate (along with naming all the month fields accordingly).

Sounds a bit far fetched - but I think it must be able to be done... somehow? I'm not very good with code - so I'd like to ask some experts!

Any help would be appreciated

NKA

The answer's always easy - if you know it! ;-)

 

[MichaelRed]

hmmmmmmmmmmmmmmm,

It CAN be done (been there), but I'm not so sure that one who is " ... not very good with code ... " will be able to tackle it without a bit of angst and more 'help' than normally available here. The BASIC strategy is to be able to dynamically assign the month, so my approach was to just have the report 'count down' from the last month to report back to the first one (as Mo13, Mo12, Mo11, ... Mo01) and "alias" the actual month's to these 'names'. Or fourse it is necessary to do much the same in the report labels as well, but in reverse.

As an aside, getting 14 columns of info on a report is a real pain -at least for the standard letter size sheets.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[NKA]

Thanks for that! Something told me it wasn't going to be easy that's for sure!

I do have 14 columns currently on the report, but as I said - I manually change the field source every month! I just want to make my life easier in the longrun - so if it means a few headaches to get this working - so be it!

Cheers

NKA

The answer's always easy - if you know it! ;-)