I have a database with 4 columns
id name birthday passingDay
I already have a select that gets the records for the current month and sorts by birthday
How do I sort the records so the they are sorted by day of month based on birthday AND passing?
So...if there are two records and one has a birday of 01/02/1948 and a second record has a date of passing of 01/02/2010
My sort would place them both after the records where day of birthday/passing = 1first and before all records with a day of month for birthday/passing = 3
Then they'd be sorted by name after the day on month(s)
I needd this in bth SQL and MSAccess