Sorting contents from multiple fields
Is it possible to sort contents from multiple fields? I have a database set up for my piano studio. Within each record (families enrolled) I have multiple fields listing the names and DOB of students within that family. I would like to make one list of all the students & their birthdays sorted in chronological order by birthday. I know how to sort the contents of a single field. Is it possible to to sort three different fields and return a combined result?