Can not sort by Sum Of Hours

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

Ive made a report and on this report is only two fields,,One field is the
name and the other is a SumofHours, this report is generated off of a
query..I would like to sort on the SumOfHours field,,Ive made this report
from the wizard..I can sort on name because it has a group header, but the
sumofHours does not have its own header because it right below the name
header...I like the way it presents itself, but can not sort from < >..Does
the query need to be refreshed every time I open the report first?..Bill
 
Are you saying that for each name, there is only one number (SumOfHours)?
And that you have Grouped on Name?

A sort can't override a grouping, but you can remove the grouping and sort
first on sum of hours. Or, if there are multiple SumOfHours for each name,
you can sort within the grouping.

The Sort Order of the Query, by the way, is immaterial to the order of
records shown in the Report -- that is solely controlled by the Report's
Sorting and Grouping Properties.

If you'd clarify, perhaps we'd be better able to help.

Larry Linson
Microsoft Access MVP
 
Yes, there should be only one name and the sumofHours below or to the right
of Name.. I really wouldnt need to use the wizard, but it actually takes
care of the code for the report..I only need to have each name one time on
the report, and beside the name a SumofHours for all of the Records, and
have report sorted by 'SumOfHours only..Bill
 
Sounds to me as if the simplest approach to your problem is to create a
Totals Query and use that as the Record Source for the Report.

Alternatively... if I ever did this, it was a long time ago, do not include
a Detail section, but only a Group Footer with the Sum... in this case, the
Report would have a normal SELECT query as its RecordSource.

Larry Linson
Microsoft Access MVP
 
Back
Top