How do I sort a column of 5+ birthdates by year in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a directory with a list of children's names &
birthdates.(01/15/99etc.)
I am having trouble getting the list of birthdates to sort by year. It will
only sort by the month.
In the query I sort by Ascending, also in the report sorting & grouping.
Do I need to write an expression? If so, what is the wording? And where do I
put it?
Thanks
 
I've never had any trouble sorting by dates, in a date/time field. Are you
keeping your birthdates in a text field? Sounds to me as if you may be.
Please clarify. You can, of course, create a calculated Field in the
Query... = Year([BirthDate])

<substitute your own field name for BirthDate>

Larry Linson
Microsoft Access MVP
 
Yes it worked!
Thanks

Larry Linson said:
I've never had any trouble sorting by dates, in a date/time field. Are you
keeping your birthdates in a text field? Sounds to me as if you may be.
Please clarify. You can, of course, create a calculated Field in the
Query... = Year([BirthDate])

<substitute your own field name for BirthDate>

Larry Linson
Microsoft Access MVP


ChurchSecretary said:
I am making a directory with a list of children's names &
birthdates.(01/15/99etc.)
I am having trouble getting the list of birthdates to sort by year. It will
only sort by the month.
In the query I sort by Ascending, also in the report sorting & grouping.
Do I need to write an expression? If so, what is the wording? And where do I
put it?
Thanks
Click to expand...
Click to expand...
 
Back
Top