Sorting

[mjdavie]

Could anybody tell me if it is possible to sort by a text box in a report and if so how can I do it ?
I have a text box which calculates totals within a group but I would like to sort by the total.
Thanks

 

[mph1]

Try using the Sorting & Grouping in the design view of the report. Select the field to be sorted and choose ascending.

HTH

 

[mjdavie]

My trouble is that it is not a field but a text box and therefore I can't select it from the sorting and grouping option.

 

[mph1]

If your report is off a query, which would be the best, the only other thing I can think of is to create a total formula in the query, then choose sorting in query.

HTH