I have a form that inserts the month name (January, February etc) in a DB. Acccess (XP) only accepts the month name as a text field. I tried changing it to a date/time field inputing the month name as 01.01 which results in January etc. However when retrieving the data (DMX) it returns as 01.01.01 AM and not as the month name.
I need to sort the results by month and am lost in finding a viable solution.
This could be solved by either:
- finding a way how Access accepts the Month name and allows sorting (not in alphabetical order)
- finding a way to retrieve date/time from the DB and replacing it by the proper Month name.
Any ideas are welcome.
Thanks
Ed

make another field of numbers 1-12 that correspond to the months and sort by that field