Sorting dates

  • Thread starter Thread starter stephanie
  • Start date Start date
S

stephanie

I want to sort dates in a query by the day. They're
listed mm/dd/yyyy. Right now it sorts by year. How do I
make it sort by day?
 
You need to change the Data Type to Text.
Your date will now appear as: 15-Mar-02
but you will be able to sort by day date.

Good Luck!
 
One easy way would be to create another field in your
query like this:
DaySort:Day([DateFieldInQuery]) and set the sort order to
ascending or descending depending on what you want.
HTH
Tom
 
Tom,

You're awesome. It works great. I'm learning something
new about ACCESS every day. Today is a good day.

Steph
-----Original Message-----
One easy way would be to create another field in your
query like this:
DaySort:Day([DateFieldInQuery]) and set the sort order to
ascending or descending depending on what you want.
HTH
Tom
-----Original Message-----
I want to sort dates in a query by the day. They're
listed mm/dd/yyyy. Right now it sorts by year. How do I
make it sort by day?
.
Click to expand...
.
Click to expand...
 
Tom,

Ok, as I said in my last post it works, HOWEVER, I can't
save it. I asked if I want to save...I say yes...then it
says "record is deleted". Do you have any clue?

Steph
-----Original Message-----
One easy way would be to create another field in your
query like this:
DaySort:Day([DateFieldInQuery]) and set the sort order to
ascending or descending depending on what you want.
HTH
Tom
-----Original Message-----
I want to sort dates in a query by the day. They're
listed mm/dd/yyyy. Right now it sorts by year. How do I
make it sort by day?
.
Click to expand...
.
Click to expand...
 
Ok, disregard my last post. Guess once you post, you
can't delete it. I figured it out. I had a ":" before
it. I deleted that and it saves fine now.

Thanks again,
Steph
-----Original Message-----
Tom,

Ok, as I said in my last post it works, HOWEVER, I can't
save it. I asked if I want to save...I say yes...then it
says "record is deleted". Do you have any clue?

Steph
-----Original Message-----
One easy way would be to create another field in your
query like this:
DaySort:Day([DateFieldInQuery]) and set the sort order to
ascending or descending depending on what you want.
HTH
Tom
-----Original Message-----
I want to sort dates in a query by the day. They're
listed mm/dd/yyyy. Right now it sorts by year. How do I
make it sort by day?
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top