sorting Format(Date)

[apestaart]

In a query I use an expression to format a data to mmm and yy. This is used in a report detail.
I want to sort on the date bit after format it is treated as text. So it starts with April, August etc.

 Expr1=(Format([Date];"mmm"" """yy"))

How can I solve this?
apestaart

 

[SgtJarrow]

You can add another field to the query, with the raw dates in it and sort based on that field. Then this field is just for "display" purposes.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[apestaart]

Just as simple as that!
Thanks,
Apestaart