This is probably something very simple, but it's in a long line of tiny hiccups.
I have a report based on a query that when ran requests both the Month and Year be entered.
The details in the report run as they should, I have no problem there, but in the Report Header I have a text box with the formula =Format([Enter Month],"mmmm") -- simple enough, right?
The report does not ask me to enter the Month twice (once for the query and again for the formula) leading me to believe that it is taking the information from what is entered for the query.
However, when 1 is entered, the formula displays December. When any other number (2-12) is entered, the formula displays January.
Not sure if this has anything to do with it, but the months stored in the table and resulting query are formatted as numbers (the reason why I am only entering numbers 1-12 for the report) as they are calculated from the date in another field and do not contain a complete date -- this seemed to make queries simpler.
What is going on?