Sorting formula results in Access Reports - HELP!!!!

[meaganewton]

Hi anyone/everyone. I can not, repeat CAN NOT, get my report in Access to sort by a specfic column. The column contains a formula (fields from a query it is linked to). For example the formula is A/B*C, and I want the column to sort descending order on the formulas result. However, when I try to sort the column, I am only allowed to sort by A B or C, not the formuals result. It's driving me batty....please help!

 

[meaganewton]

I don't know how to add the caluclation as a new field in my query....is that a whole new column?

 

[Golfer]

Use this in your qbe grid
Formula Result: [Your Table Name]![A]/[Your Table Name]!*[Your Table Name]![C]