order by calculated text box

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Hi

I have a form whose record source is a Crosstab Query that has a variable
number of fields for Accounts and each Account's quarterly totals.
I have a button on the form that assigns the ControlSource of the following
fields to the controls that display each quarter's total for one year at a
time.

The fields are:
Qt1Total, Qt2Total, Qt3Total, Qt4Total

I have a text box in the detail that totals all 4 quarters.
How can set the orderby property to sort by the calculated text box.

I will credit any helpful responses

Thanks
 
Hi

Actually I described the RecordSource incorrectly. The RecordSource is
actually a table that was created from the crosstab query. I did this to
improver performance of the form.

Thanks
 
Back
Top