sorting question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve goodrich - 28 May 2007 17:18 GMT

I have a database which includes a date of birth field'
I run a report based on a query showing me the "birthdays this month"
I added a column to the query Month([date of birth]) criteria Month(Now())
I would like to sort the birthdays by day - when I sort by the date of birth
it sorts by year
how do I get it to sort by day
many thanks
Steve

Reply to this Message

fredg - 28 May 2007 18:10 GMT

> I have a database which includes a date of birth field'
> I run a report based on a query showing me the "birthdays this month"
[quoted text clipped - 4 lines]
> many thanks
> Steve

If this is in a report, then the sorting order of the query is
irrelevant.
You must sort the report in the report's Sorting and Grouping dialog.
In Report Design View, click on View + Sorting and Grouping.
In the Field/Expression column, write on the top line:

=Format([DateOfBirth],"dd mm")
Set the sort to Ascending.

Since your query is being filtered to return only the current month
birth dates, the report will display the records sorted by that
month's days.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

steve goodrich - 28 May 2007 19:48 GMT

Many thanks Fred, worked perfectly

>> I have a database which includes a date of birth field'
>> I run a report based on a query showing me the "birthdays this month"
[quoted text clipped - 19 lines]
> birth dates, the report will display the records sorted by that
> month's days.

Reply to this Message