Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello, I have a query and report that prompts the user to enter a month (e.g. 1,2,3 etc) I'd like to add the month in the header of the report created using this query. Currently is shows the month number, but I'd like to change it to text (e.g. 1-January, 2-February, 3-March etc.) would I do this in the query itself or in the properties of the textbox I've placed the formula in on the report......I thought I'd fix it by creating a table with the months listed with a autonumber, but now I dont' know how to add the table to the query expression or to the report textbox.....HELP