How do you sort 2 date fields in assending order (query or report)

  • Thread starter Thread starter KnowEnough2BDangerous
  • Start date Start date
K

KnowEnough2BDangerous

I have 2 DOB fields (client and spouse) in a table that I currently print off
the birth month and call them on their b-day. I really wish I could figure
out how to get them to print/display in assending order of date (ie: 11/1
followed by 11/2) even if the spouse is before the client. Is this possible
without having to do a bunch of programming? Thanks!
 
Yep. Use a calculated field like this --
DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB], [Spouse_DOB])
 
Back
Top