>I have been asked to order a set of insurance records as follows:
>
>Insured
>Spouse
>Child 1 Oldest
>Child 2 Next to Oldest
>Child 3 Youngest
>
>I know that I can put the children in order by their birth dates, but how do I order the data to get the Insured Member first and Spouse 2nd and then the children by birth dates? Is this do-able?
>
>I cannot do a simple index, it appears.
>
>Cecil
Assuming "Insured" and "Spouse" are logical fields, and there is a field for BirthDate (D):
SELECT ... ORDER BY insured DESC, spouse DESC, BirthDate
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
