G Guest Dec 29, 2004 #1 I want to sort dates that have various years but I want them to group (sort) by month/day. Any suggestions?
I want to sort dates that have various years but I want them to group (sort) by month/day. Any suggestions?
G Guest Dec 29, 2004 #2 Make a query where you build a field like this: Month: Format([tblMain]![DateEntered],"mm/dd") ChrisJ Omaha
Make a query where you build a field like this: Month: Format([tblMain]![DateEntered],"mm/dd") ChrisJ Omaha
J John Vinson Dec 29, 2004 #3 I want to sort dates that have various years but I want them to group (sort) by month/day. Any suggestions? Click to expand... Two ways: - Add a calculated field to the Query by putting MonthDay: Format([datefield], "mmdd") in a vacant Field cell, and sort by this; or - Add two calculated fields Month([datefield]) and Day([datefield]) and sort by them. John W. Vinson[MVP]
I want to sort dates that have various years but I want them to group (sort) by month/day. Any suggestions? Click to expand... Two ways: - Add a calculated field to the Query by putting MonthDay: Format([datefield], "mmdd") in a vacant Field cell, and sort by this; or - Add two calculated fields Month([datefield]) and Day([datefield]) and sort by them. John W. Vinson[MVP]
