Sorting one way for one group and another way for another group

[Guest]

Hello.

I am working on a report that lists stocks we are watching. We have two
types of positions we are looking at - Long and Short. For each stock we have
a target price and a calculation to show whether the current price is above
or below that target (call it premium and discount for above and below
respectively).

I have set-up the report to group on Long or Short without problems. What
I'd like to know is if there is a way that I can have the report sort
descending for Short but sort ascending for Long. Is this possible?

Thanks!
CKD

 

[Duane Hookom]

I'm not real sure about your request but assuming you have gender and salary
fields in your report. You want to sort Females by Descending salary and
Males by Ascending salary. You could try use an expression like:

=IIf([Gender]="F",-[Salary], [Salary]) Ascending

 

[Van T. Dinh]

(already answered in "queries" newsgroup).

Please do NOT multi-post the same question in different newsgroups.

Please see The Access Web article:

http://www.mvps.org/access/netiquette.htm