Sorting a field with calculations in it in a report.

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a field called [Total] in my database that adds the numeric values of
several other fields. The [total] field is in a report. I want the report
to sort ascending on the [Total] field. How can I do this?

Any help is greatly appreciated.
 
Frank said:
I have a field called [Total] in my database that adds the numeric values
of several other fields. The [total] field is in a report. I want the
report to sort ascending on the [Total] field. How can I do this?

Any help is greatly appreciated.
Click to expand...

Do the totalling in the query that feeds the report:

Field1 + Field2 As Total

This'll give you an extra column called Total on which to sort/filter in the
report.
 
Frank said:
I have a field called [Total] in my database that adds the numeric
values of several other fields. The [total] field is in a report.
I want the report to sort ascending on the [Total] field. How can
I do this?

Any help is greatly appreciated.
Click to expand...

Do the totalling in the query that feeds the report:

Field1 + Field2 As Total

This'll give you an extra column called Total on which to
sort/filter in the report.
Click to expand...
Another way to accomplish the sort is to add the calculation to a
row in the Sorting & Grouping dialog of the report, preceeded by an
equals sign.
 
Bob Quintal said:
Frank said:
I have a field called [Total] in my database that adds the numeric
values of several other fields. The [total] field is in a report.
I want the report to sort ascending on the [Total] field. How can
I do this?

Any help is greatly appreciated.
Click to expand...

Do the totalling in the query that feeds the report:

Field1 + Field2 As Total

This'll give you an extra column called Total on which to
sort/filter in the report.
Click to expand...
Another way to accomplish the sort is to add the calculation to a
row in the Sorting & Grouping dialog of the report, preceeded by an
equals sign.
Click to expand...

Yes with the caveat that you still need to display the calculated field in
the report, thereby having the same calc in two places. If one is altered
for some reason at a later date, you must remember to alter the other. A bit
too error prone for the way I work (I'd _always_ forget :)
And t'would be a bitch for any developer who succeeds me.
 
Thanks all for most helpful posts. I opted for a new calculated field
resident within a Query . All works great and everything in River City is
now cool!!
 
Back
Top