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

Add a keyID to activity type

Aloha...

I'm not a programmer, but I wonder if you could add a column to the combo box which would contain numeric values, ie 1, 2, 3, ..., with the matching column being the Activity Type listed in order of priority. Then it seems that you could tell the query to sort on the numeric column.

Just guessing.

Tana