Sorting and Grouping

[bw]

I have the following in the Sorting and Grouping Box (I hope this formats
okay):

Field Sorting Group Header Group Footer Group
On
Billed Ascending No No
Each Value
BillDate Descending Yes Yes
Year
BillDate Ascending No No
Each Value

Billed is a Yes/No Field
BillDate is a Date Field

When Billed is "Yes", I want to use the above Sorting and Grouping.
When Billed is "No", I want the first BillDate above to Sort Ascending.

Does anyone have a suggestion as to how to do this?

Thanks,
Bernie

 

[Marshall Barton]

I have the following in the Sorting and Grouping Box (I hope this formats
okay):

Field Sorting Group Header Group Footer Group
On
Billed Ascending No No
Each Value
BillDate Descending Yes Yes
Year
BillDate Ascending No No
Each Value

Billed is a Yes/No Field
BillDate is a Date Field

When Billed is "Yes", I want to use the above Sorting and Grouping.
When Billed is "No", I want the first BillDate above to Sort Ascending.

Change the first BillDate entry to something like:
BillDate Ascending Yes Yes Each Value
=Year(BillDate) * IIf(Billed, 1, -1)

 

[bw]

Change the first BillDate entry to something like:
BillDate Ascending Yes Yes Each Value
=Year(BillDate) * IIf(Billed, 1, -1)

The actual code that worked was: =[BillDate]*IIf([Billed],-1,1)
It's just amazing what we learn here. It's just amazing what you guys
know.

It never occurred to me to use a formula in the Sorting and Grouping
box.
Thanks for your help again, Marshall.
Bernie