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

  • Thread starter KnowEnough2BDangerous
  • 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!
 
K

KARL DEWEY

Yep. Use a calculated field like this --
DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB], [Spouse_DOB])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to sort a report assending but it won't do it. 2
Combine 2 text fields into one 2
Query SQL 4
Birthday Querie (For multiple Birthdates in each record 5
Preferred way to do sort order - column in table, or specified in query? 3
Still stumped - can't get a date (range). 6
Sorting and Preventing Blank Lines 2
dates in table 2 fields need to be one field I can sort by date on 5

Top