Sorting dates

[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?

 

[Liz]

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!

 

[Tom]

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

 

[Stephanie]

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:
DaySortay([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?
.

.

 

[stephanie]

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:
DaySortay([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?
.

.

 

[stephanie]

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:
DaySortay([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?
.

.

.