Wrong total in report footer

  • Thread starter Thread starter Sadik
  • Start date Start date
S

Sadik

Hi everyone,

Like I am not very good in english, i'll make it as simple as I can.

Here is my problem:

I have the following report which represent a quotation of multiple
assemblies of parts for a given client.
This report is from a query I made to filter a certain quotation number via
a form.

-Report header-
-Page header-

Client info, quotation number, contact info, etc

-Assembly header-

Assembly number, quantity, price of assembly

-Detail header-

Parts in assembly, material, gage

-Page footer-
-Report footer-

=Sum([quantity]*[price])

----------------------------------------

I get this result:

Assembly number Parts in assembly material gage quantity
price of assembly

MT-37
100 5$
MT-37-1 blabla bla
MT-37-2 blabla bla

MT-31
50 2$
MT-31-1 blabla bla
MT-31-2 bla
bla



Grand total: 1200$


I don't want 1200$, it should be (100*5$) + (50*2$) = 600$

Any help?

Maybe the answer is obvious but I just don't get it this time. Thank you
all.
 
If the values are totaled from a group header, you should create at text box
in the group header:
Name: txtCostRunSum
Control Source: =[Quantity] * [Price]
Running Sum: Over All
Then add a text box to your report footer:
Control Source:=txtCostRunSum
 
Back
Top