Convert text into Date in a query

B

Bdavis

I have expression field that combines the month and year field in a table
however, I can't Acees to treat the new field as a date for soring purposes
etc. Is there a conversion function or some other meathod of achieving this?

Thanks,
Ben
 
K

Ken Snell [MVP]

Please provide examples of the data values that result from the expression
and explain how you want to use those values for sorting (again, examples).
I assume that you're doing this in a query?
 
Top