Multi-Column sorting question

[davedz]

I have a database that tracks music, specifically records. Assume I have a date in Column A for pop music and a date in Column B for R&B records. Some records may have a date in both columns, some only in one column. Is there a way to do a "merged" sort so the dates in Column A & B would be sorted in sequential order whether the date is in Column A or B, or both.

[comment]

You could define a calculation field (result is Date) =

Case ( Column A ; Column A ; Column B )

and sort by this field.

[davedz]

Thank you! This does exactly what I needed.

Dave