Ordering a Calculated field on a report

[Clem]

I trying to order a report using a calculated field but seem to get nowhere. The calculated field is not a database column. Here is an example of the report.

Field 1 Field 2 Sum of F1&F2
5 .......... 7 ........... 12
14 ......... 8 .......... 22
7 ......... 9 ......... 16

What I want to do is this

Field 1 Field 2 Sum of F1&F2
14........ 8 ....... 22
7 ........ 9 ....... 16
5 ........ 7 ....... 12

Can anyone help. I should be very grateful.

 

[KenHigg]

Can you calculate it in the reports query then sort on it?

 

[Clem]

I might be able to if I knew how! Can you explain how to include a calculating field in a query?

 

[arnelgp]

another approach is to build query:

select field1, field2, field1+field2 as field3 from table order by field1+field2

use the query as recordsource of your report.

 

[KenHigg]

In the query builder, instead of just selecting the column name do something like

MyCalculatedFldName: FldName1 + FldName2

to add two fields, etc...

 

[Clem]

To all who responded to my Post. Thank you so much, this site is so useful and the responders so helpful. Thank you again.