Creating a month field

[mccallen60]

Hello,
I receive a monthly report of total prescriptions processed from a
independent vendor. This report utilizes a rolling 24 months.

TRx Month24 TRx Month23 TRxMonth22 ........
247.12 258.69 308.45

TRx Month24 is the current data. When I receive ths report in September, TRx
Month24 is data from August, TRx Month23 is data from July, etc.The vendor is
always on month behind.

What I need to do is replace the field header from TRx Month## to the month
and year the data represents (ex: replace TRx Month24 with Aug09TRx, replace
TRX Month23 with July09TRx, etc all the way to TRx Month01).

It's a pain re-typing these months all the time.

Thanks in advance! Kevin

 

[Jeff Boyce]

"... receive a ... report"

Does that mean you get a paper print out? How is this data ending up in
Access? This is an question about Access, right?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

 

[PieterLinden via AccessMonster.com]

Hello,
I receive a monthly report of total prescriptions processed from a
independent vendor. This report utilizes a rolling 24 months.

TRx Month24 TRx Month23 TRxMonth22 ........
247.12 258.69 308.45

TRx Month24 is the current data. When I receive ths report in September, TRx
Month24 is data from August, TRx Month23 is data from July, etc.The vendor is
always on month behind.

What I need to do is replace the field header from TRx Month## to the month
and year the data represents (ex: replace TRx Month24 with Aug09TRx, replace
TRX Month23 with July09TRx, etc all the way to TRx Month01).

It's a pain re-typing these months all the time.

Thanks in advance! Kevin

Sounds like if you "undid" his crosstab data and stored it as
(Month, Year, Value), you could create your own crosstabs really easily by
creating a select query that selected the records based on the current month
and then created a crosstab based on that.

 

[KARL DEWEY]

Sounds like a spreadsheet. Just copy and paste what you did last month.