F Floyd Forbes Jul 3, 2005 #1 Help please, Is there a way to sort on a calculated field on a report? Floyd
A Allen Browne Jul 3, 2005 #2 Yes: create a query to feed the report, and put the calcuation in the query. In query design view, you can enter a calculation into the Field row of the grid, e.g.: Amount: Quantity * PriceEach Then use that query as the RecordSource of your report, and you can use the Amount field just like any other field. If you get all that working, but the sorting is not what you expect, see: Calculated fields misinterpreted at: http://allenbrowne.com/ser-45.html
Yes: create a query to feed the report, and put the calcuation in the query. In query design view, you can enter a calculation into the Field row of the grid, e.g.: Amount: Quantity * PriceEach Then use that query as the RecordSource of your report, and you can use the Amount field just like any other field. If you get all that working, but the sorting is not what you expect, see: Calculated fields misinterpreted at: http://allenbrowne.com/ser-45.html
