Creating a month field

  • Thread starter Thread starter mccallen60
  • Start date Start date
M

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
 
"... 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
 
Back
Top