Creating a month field

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate a year to date 6
How to get all records in a Query even you select a record from a conbox box 2
Pull year and month from date field using parameter query 8
CCleaner Compromised to Distribute Malware for Almost a Month 10
Sorting by Month problems with Combobox 14
Single Month Format for 3 months' dates 9
Calculate last 3 full months 4
How to create a rolling 6 month average? 3

Top