Ascending/Descending Order

Hello group,

I need some help with a report I'm doing please. In my db, a person can either be an Alternate-Member, Member, Co-Chair or null. And each person belongs to a group.

My report prints the names of people and groups them by their respective groups. I need for the "Co-Chair" of each group to appear first in each subgroup. I already have it set up so that the title will only show if the title is like Co-Chair, but my problem is the order - ascending will place the null ones first, descending will place "Member" first (this is using the Sorting and Grouping button in design mode).

Any help would be greatly appreciated!

Thanks,
-Sean

Rank Member Type using number.

You could add a field in the table where MemberType (Alternate-Member, Member, Co-Chair or null) is stored and add a numberic field (MemberTypeRank) and sort on MemberTypeRank instead of MemberType.

e.g.
MemberType: Co-Chair, MemberTypeRank: 1
MemberType: Member, MemberTypeRank: 2
MemberType: Alternate-Member, MemberTypeRank:3
MemberType: null, MemberTypeRank:4

Add the MemberTypeRank to the report and set its invisible property to NO.



Hope this helps!

Thanks for answering Cosmos75!

That is a perfect solution only someone else is in charge of this particular db (and it's like their baby! - very defensive), and they did not set up tables for repeating data (ie a table with just the four titles) - so I wanted to avoid messing with their stuff, even if it is for the best. I don't think I have much choice though.

Thanks again,

-Sean

SO, there is a lookup table that stores the MemberType and the Member table look to that to assign a Member type? If so, you'd just have to add another field (MemberTypeRank) to the lookup table and use that in your query and sort by the rank. That is a small change and I can't imagine why that should be a problem.

I have discussed it with my colleague and we have added the field as you suggested (my report works great now too!).

Thanks!

-Sean

Same question! (only odering on different field - High, Medium and Low)
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=115300