Sorting date field ny day and month

[Robin Chapple]

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

 

[Douglas J Steele]

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.

 

[Robin Chapple]

Thanks Doug,

The two field option is ideal.

Many Thanks,

Robin Chapple