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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top