Dynamic Sorting

[Vel]

Hello,

How do I go about setting a report's sort levels
dynamically based on criteria in a report? Can I just
type an expression into the sort field? I tried and it
didn't seem to work.

Example, here's what I want to do:

in the View/Sorting and Grouping Dialog

Field/Expression Sort Order
forms!frmRepGen!cboA1 Ascending
forms!frmRepGen!cboA2 Ascending


Now, if I typed "DateOfService" in the combo box cboA1 on
my form, I would want it to sort by the field
DateOfService first. I tried doing it this way, but it
doesn't seem to sort by anything at all.

Vel.

 

[Duane Hookom]

This may be a first, particularly if you are using Access 2000 or later.

 

[Marshall Barton]

This may be a first, particularly if you are using Access 2000 or later.

L O L