Sorting date field ny day and month

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

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
 
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.
 
Back
Top