query sort

[jmonty]

Need to assign sort based on (3) combobox user selections
on form.
The form is similar to the Data>Sort dialog that appears
in Excel, where you select the cboFirst (ascending or
descending),
then the cboSecond has the remaining fields listed...you
select from those (asc or desc) and then
from the cboThird (asc & desc). The comboboxes work fine,
but there are so many possible variations to account for,
and I don't want to create seperate queries or reports.
How do I pass the correct sort to the (already very
complex) Report_Query?
Note: this query is the recordsource for my Report1.
I've gone blind staring at it and need a fresh perspective.
Thanx in advance for your help.

 

[Douglas J. Steele]

The sort order of a query doesn't make any difference in a report. The only
way you can control the sort order in a report is to use the Sorting and
Grouping interface in the report designer (look under the View menu if
you're not familiar with it)

 

[anngocta]

Need to assign sort based on (3) combobox user selections
on form.
The form is similar to the Data>Sort dialog that appears
in Excel, where you select the cboFirst (ascending or
descending),
then the cboSecond has the remaining fields listed...you
select from those (asc or desc) and then
from the cboThird (asc & desc). The comboboxes work fine,
but there are so many possible variations to account for,
and I don't want to create seperate queries or reports.
How do I pass the correct sort to the (already very
complex) Report_Query?
Note: this query is the recordsource for my Report1.
I've gone blind staring at it and need a fresh perspective.
Thanx in advance for your help.