Want the sum only at the end of the Detail Section .. oh ..

  • Thread starter Thread starter voovoo
  • Start date Start date
V

voovoo

The problem is I need no "Group Head" nor "Group Footer"
to set up; because this led to choose for the sorting of
either ascending or descending. But to do so, I still
need the "sum data" to be sum as at the end of the line as
the "Group Footer" invented. Thanks
 
Please use the subject line for a brief summary of your question, and post
the full question in the message section. Since you haven't explained the
details I will make some assumptions. Your report is going to be in some
order whether or not you choose it. I can't understand why you wouldn't want
to sort your reports, but one approach is to group by primary key, which will
let you have a group footer. The records will appear in the order they were
entered. Put a hidden text box set to running sum over group in the detail
section, and put a visible text box in the group footer with the control
source = Me.RunningSumTextBox.
 
voovoo said:
The problem is I need no "Group Head" nor "Group Footer"
to set up; because this led to choose for the sorting of
either ascending or descending. But to do so, I still
need the "sum data" to be sum as at the end of the line as
the "Group Footer" invented. Thanks
Click to expand...


You should use a group footer for this kind of calculation.
As for sorting the grouping field, if the field were not
sorted, they would not be "clumped" together and no one
would know which record was the last one.

Maybe I don't understand what you want and you shold explain
more about what you mean by "sum data" and how the report
and its data are organized.
 
Thank You So much.

In deed, I have tried this a lot as a challenge. I need
no "Group Footer" nor "Group Header" because the data I've
sorted is diverted in the digits of figures, the two
digits is focus into one and sorted till out of, then
begin to another four digits into focus and sorted till
out of it, then begin in another six digits into focus and
sorted till out of it. So it is set up and for the report.
If the use of "Group", this leads to resorted the
mix-up disregarded of all "two", "four", and "six" digits
into one croquette sort. As this event, needed the sum of
the each of them at end of the line as sum figures.
Thanks
 
I suspect that there is language problem here. I really do
not understand what you want to calculate. Could you post
some sample records and the results you are trying to
calculate?
 
Thank You So much.

In deed, I have tried this a lot as a challenge. I need
no "Group Footer" nor "Group Header" because the data I've
sorted is diverted in the digits of figures, the two
digits is focus into one and sorted till out of, then
begin to another four digits into focus and sorted till
out of it, then begin in another six digits into focus and
sorted till out of it. So it is set up and for the report.
If the use of "Group", this leads to resorted the
mix-up disregarded of all "two", "four", and "six" digits
into one croquette sort. As this event, needed the sum of
the each of them at end of the line as sum figures.
Thanks
 
sample of the report to be :

Degits values
51 3201
61 9703 the sum of 2 digits = 12904
5132 444
5133 2757
6111 9703 the sum of 4 digits = 12904

This's going to be the result. So if the "Group" required,
the two and the four would be sorted 51, 5132, 5133 then
61, 6111.
That's it> :)
-----Original Message-----
I suspect that there is language problem here. I really do
not understand what you want to calculate. Could you post
some sample records and the results you are trying to
calculate?
--
Marsh
MVP [MS Access]

In deed, I have tried this a lot as a challenge. I need
no "Group Footer" nor "Group Header" because the data I've
sorted is diverted in the digits of figures, the two
digits is focus into one and sorted till out of, then
begin to another four digits into focus and sorted till
out of it, then begin in another six digits into focus and
sorted till out of it. So it is set up and for the report.
If the use of "Group", this leads to resorted the
mix-up disregarded of all "two", "four", and "six" digits
into one croquette sort. As this event, needed the sum of
the each of them at end of the line as sum figures.
Thanks
line
as
Click to expand...

.
Click to expand...
 
bab said:
sample of the report to be :

Degits values
51 3201
61 9703 the sum of 2 digits = 12904
5132 444
5133 2757
6111 9703 the sum of 4 digits = 12904

This's going to be the result. So if the "Group" required,
the two and the four would be sorted 51, 5132, 5133 then
61, 6111.
Click to expand...


I am still not clear on what you're trying to do, but I
continue to think that you do need to group on something.
Maybe the grouping can be done in the query, but I think
that will be needed to calculate the Sum. We can worry
about what line the sum is on after everything else is
working.

Try setting the report's Sorting and Grouping to Group on
the expression:
=Len(CStr(Digits))
with footer section. Place a text box the expression
=Sum(values) in the group footer.

Set the second line in the Sorting and Grouping to just sort
(no header or footer) on the field Digits.

If you do that, I expect the report to produce the result:
Degits values
51 3201
61 9703
the sum of 2 digits = 12904
5132 444
5133 2757
6111 9703
the sum of 4 digits = 12904

which I think is very close to what you want.
 
Back
Top