Sort Date by day of week, not year.

[Sky]

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query that
returns birthdays by month, and I want them sorted by the
day of week. Is there a way to do this.

 

[Ken Snell]

Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc. You can then sort on
it.

Or, if you want to sort by the name of the day of the week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")

 

[Sky]

Ken,

Both suggestions worked flawlessly and I

-----Original Message-----
Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc. You can then sort on
it.

Or, if you want to sort by the name of the day of the week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")
--
Ken Snell
<MS ACCESS MVP>

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query that
returns birthdays by month, and I want them sorted by the
day of week. Is there a way to do this.

.

 

[Sky]

Ken,

Ooops! Hit a key by accident so didn't finish reply.
Anyway, the two suggestions work but I wonder if it's
possible to have both the Month and Day appear and be
sorted by the Day.

If not, I'll settle for what I have. At any rate, thanks
Ken for giving me some life here. Your knowledge is
invaluable!!!

-----Original Message-----
Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc. You can then sort on
it.

Or, if you want to sort by the name of the day of the week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")
--
Ken Snell
<MS ACCESS MVP>

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query that
returns birthdays by month, and I want them sorted by the
day of week. Is there a way to do this.

.

 

[Ken Snell]

If you want to show the Month and Day as separate fields in the query,
simply create another calculated field in the query:
MonthName: Format([DateFieldName], "mmmm")

--
Ken Snell
<MS ACCESS MVP>

Ken,

Ooops! Hit a key by accident so didn't finish reply.
Anyway, the two suggestions work but I wonder if it's
possible to have both the Month and Day appear and be
sorted by the Day.

If not, I'll settle for what I have. At any rate, thanks
Ken for giving me some life here. Your knowledge is
invaluable!!!

-----Original Message-----
Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc. You can then sort on
it.

Or, if you want to sort by the name of the day of the week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")
--
Ken Snell
<MS ACCESS MVP>

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query that
returns birthdays by month, and I want them sorted by the
day of week. Is there a way to do this.

.

 

[Sky]

Ken,

Great idea! It works like a charm. Your the best dude!

Thanks a zillion times over...

-Sky

-----Original Message-----
If you want to show the Month and Day as separate fields in the query,
simply create another calculated field in the query:
MonthName: Format([DateFieldName], "mmmm")

--
Ken Snell
<MS ACCESS MVP>

Ken,

Ooops! Hit a key by accident so didn't finish reply.
Anyway, the two suggestions work but I wonder if it's
possible to have both the Month and Day appear and be
sorted by the Day.

If not, I'll settle for what I have. At any rate, thanks
Ken for giving me some life here. Your knowledge is
invaluable!!!

-----Original Message-----
Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc. You can then sort on
it.

Or, if you want to sort by the name of the day of the week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")
--
Ken Snell
<MS ACCESS MVP>

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query that
returns birthdays by month, and I want them sorted

by
the

day of week. Is there a way to do this.




.

.

 

[Ken Snell]

You're welcome.

Ken,

Great idea! It works like a charm. Your the best dude!

Thanks a zillion times over...

-Sky

-----Original Message-----
If you want to show the Month and Day as separate fields in the query,
simply create another calculated field in the query:
MonthName: Format([DateFieldName], "mmmm")

--
Ken Snell
<MS ACCESS MVP>

Ken,

Ooops! Hit a key by accident so didn't finish reply.
Anyway, the two suggestions work but I wonder if it's
possible to have both the Month and Day appear and be
sorted by the Day.

If not, I'll settle for what I have. At any rate, thanks
Ken for giving me some life here. Your knowledge is
invaluable!!!



-----Original Message-----
Add a calculated field to your query:
DayOfWeek: DatePart("w", [DateFieldName])

This function returns 1 for Sunday, 2 for Monday, etc.
You can then sort on
it.

Or, if you want to sort by the name of the day of the
week, add a calculated
field to your query:
DayOfWeek: Format([DateFieldName], "dddd")
--
Ken Snell
<MS ACCESS MVP>

Hello,

Is there a way to force Access 2000 to sort the Date by
the day of week, instead of by year. I have a query
that
returns birthdays by month, and I want them sorted by
the
day of week. Is there a way to do this.




.

.