in tblActivities, I have:
MemberID - primary key
Date
ActivityType - combo box with 13 possible entries.
I use a query to generate a subform to display a members activity history on a mainform and the query is told to display sorting on date. It seems a natural second sort is happening where if there are multiple entries for the same date, it's looking at the ActivityType and putting it in alphabetical order.
I need to have it sort by date first, so this is ok, but the second sort should be by order of importance, i.e. Demitted after Initiated, etc.
Is there a way to force a specific order based on the ActivityType?
Bluez
MemberID - primary key
Date
ActivityType - combo box with 13 possible entries.
I use a query to generate a subform to display a members activity history on a mainform and the query is told to display sorting on date. It seems a natural second sort is happening where if there are multiple entries for the same date, it's looking at the ActivityType and putting it in alphabetical order.
I need to have it sort by date first, so this is ok, but the second sort should be by order of importance, i.e. Demitted after Initiated, etc.
Is there a way to force a specific order based on the ActivityType?
Bluez