sort month/year

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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


[MVP] S.Clark said:
Try adding format('yymm", [daterecvd]) and sort by it.

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


SaraR said:
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!
Click to expand...
Click to expand...
 
Back
Top