Sorting by a Summed Text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has a textbox(txt_sum) that sums one of my fields. The
txt_sum is located in the "Employee Footer", is there any way to sort my
report by this summed textbox? The textbox control source is not from a
field in my table so if it is possible to sort the report by I cannot figure
out how. Any help or suggestions would be great. If i was unclear please
feel free to ask me more details. Thanks in advance.

Dave
 
You can't sort by an aggregate value in a report. You can create a query
that totals by employee and calculates your sum. Then add this totals query
to your report's record source so the sum can be used for sorting.
 
Select View->Totals in query design. Group by EmployeeID and sum "one of my
fields". Save the query as "qtotEmployeeSum". Add the query to your report's
record source.

You may will need to change field names to match your application.
 
Back
Top