sort month/year

[Guest]

I created a simple query where my column "daterecvd" is formatted in
date/time. Query sorts by month but not chrono. The year is out of order.
It sorts as follows:
Dec 2004
Jan 2005
Nov 2004
Oct 2004
Sept 2004.

Field: DateRecvd By Mon
Total Group By
Thanks!

 

[[MVP] S.Clark]

Try adding format('yymm", [daterecvd]) and sort by it.

 

[Duane Hookom]

Oops, should be
Format([DateRcvd], "yyyymm")
This assumes DateRcvd is a date/time field. If it's not, it should be.

--
Duane Hookom
MS Access MVP

Try adding format('yymm", [daterecvd]) and sort by it.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

I created a simple query where my column "daterecvd" is formatted in
date/time. Query sorts by month but not chrono. The year is out of
order.
It sorts as follows:
Dec 2004
Jan 2005
Nov 2004
Oct 2004
Sept 2004.

Field: DateRecvd By Mon
Total Group By
Thanks!