Convert numbered months to text

[bkolbow]

The database I'm working on uses numbers for months instead of text. I've had a request to replace the numbers (1-12) with the months (January - December)in reports. I think this is probably a macro function but I'm not sure. Does anyone have any hints???

Thanks, in advance, for your help!

 

[Fornatian]

What I would do is build a small table called Nos2Mths with two fields.

Fld1(Primary)
Name:Number
Type:Byte

Fld2:
Name:Month
Type:Text(9 length)

Enter all twelve months numbers and their corresponding text values.

Then in the your reports query, put No2Mths in the QBF grid and put a join line between the Nos in your original data and primary key of the Nos2Mths table.

Include the new field Month as a column and the month text should be pulled through automatically.

If your boss doesn't want to see the month number in the report you can always make it invisible anyway.

This is how I'd do it because then you don't have to mess about with the inputting procedures and changing numbers to text.

HTH

Ian