I am working on creating a database to keep track of a track and field meet. I created a name, gender, grade level, meet, event, and score fields. I would like to be able use the find to get just that meet active, then do a sort by event and score to get the results. I would also like to be able to have the database label 1st-5th place for each event. One problem I see already is that the field events go in descending order, while running events go in ascending order. Any ideas?
Consider putting Time resulits in one field and distance results in another. Then you can sort by both fields (time in ascending order and distance in descending order) and then both types of events will sort in the correct order.