Sorting date field ny day and month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 05 Jul 2006 13:11 GMT

I have a membership database which records date of joining.

I need to mention anniversaries in a weekly bulletin and therefore
need to sort my report by day and month.

How do I do that? I do not know where to start.

Thanks,

Robin Chapple

Reply to this Message

Douglas J Steele - 05 Jul 2006 13:51 GMT

Simplest way would be to base your report on a query, and have one (or two)
computed fields in that query in addition to whatever other fields you need.

If you go the one-field route, use Format([AnniversaryDate], "mmdd"). For
the two-field route, use Month([AnniversaryDate]) and
Day([AnniversaryDate]).

In the report, select the computed field(s) in the Sorting and Grouping
dialog to have your report sort correctly.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have a membership database which records date of joining.
>
[quoted text clipped - 6 lines]
>
> Robin Chapple

Reply to this Message

Robin Chapple - 06 Jul 2006 00:51 GMT

Thanks Doug,

The two field option is ideal.

Many Thanks,

Robin Chapple

>Simplest way would be to base your report on a query, and have one (or two)
>computed fields in that query in addition to whatever other fields you need.
[quoted text clipped - 5 lines]
>In the report, select the computed field(s) in the Sorting and Grouping
>dialog to have your report sort correctly.

Reply to this Message