Sorting by Format criteria - Any Suggestions?

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

Guest

I have used a Left and Right formatting to get the Month and Year (leaving
the day) of a date. When I sort by this new date format, I get the
following..

1/04
1/05
1/06

2/04
2/05
2/06

I understand what it's doing, but what I want is for it to sort by year and
then month.

Any suggestions are welcome.

Thanks
 
Easiest way to do this would be to insert the source date field into
the query that your month/year is based on, sort by it, then uncheck
the show box for that field.

Keven
 
Uhh...that's what I assumed you meant and that's what I'm saying,
adjust your query.

Your query should consist of exactly what is in it at the moment, plus
whatever field you are using to get your month/year calculation from.
So if your month/year is calculated from the StartDate field, add the
StartDate field to your query, sort by it, then uncheck the box in the
show row of the query design.

Keven
 
CompGeek78,

Although I was trying that ... I think because I convaluted it with other
fields and was making it harder than it is ... it wasn't working. However, I
just started over with simplicity (at your suggestion) and it worked.

Thank you so much.
 
I know you knew I was using a query. I was trying to add that little bit of
info, but when I hit send and then refresh your reply with an answer was
already there.

Timing is a lot when sending replys or updated replys.

Again, Thanks
 
Back
Top