Unanswered: Expression builder help. Month Name to Number
This was posted earlier, thought I had a solution but it did not work with my application. becuae i cannot use modules in the query with ODBC (did'nt know that till to late)
I have an Access database query with a month column (with full names of months in them) . I need to build an expression that will take
DECEMEBER and make it 12
November and make it 11
October and make it 10 and so on.
I tried this and it worked for 1 month at a time ****** Expr1: IIf([month]="January","1") ****** but how would I format it to make all the months corespond with the right number?
The table value is not a month field it is a text field. so I don't think any of the date variables will work. I hope this is simple one for you access guys out there. I really need some help on this one. 10 hours I have been working on tis .... I am drained