How do a get a report to sort on a calculated field?

S

Stu

I have a report which has a calculated date field I want
sorted in ascending order. Since this does not appear in
any of the tables, it does not show up in "Sorting and
Grouping". How do I get the report to sort on a
calculated field?
 
D

Douglas J. Steele

Can you do the calculation in a query and use that query as the
recordsource?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort order in report 2
sort alphabetical in report 4
Want Sum in Report Header of calculated field in Report Detail ? 1
Access MSACCESS - Sorting report based on field calculated in the report 0
Sorting on Calculated fields 2
Sorting by a calculated field 12
Sort Multiple Fields in a Report 1
sort calculated field 6

Top