Convert text into Date in a query

[Guest]

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

 

[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?

 

[Guest]

Hey Ken,

Thanks for responding but I managed to figure it out.