Calculating Grand total

[Cybermac]

Hi Guys, how do i calculate grand totals of price in form detail and put it on form footer?
example:
form header
----------------------------
item qty price total price
----------------------------
details
books 5 1.00 5.00
pencil 2 3.00 6.00
----------------------------
form footer
Grand total 11.00 <- how should i do this Grand total
----------------------------

 

[petrosky]

Hi Cybermac,

You generally would have a field on your footer which was

=sum([qty]*[price])

If it is located on a sub form. You can have this field above set to hidden and refer to it on your main form/report.

=[yoursubformname].[Form]![Total]

Where Total is the name of the field you created.

I hope this helps.

Regards,

Peter

Remember- It's nice to be important,
but it's important to be nice

 

[Cybermac]

Thanks petrosky, but #error encountered when i put that formula in control source of textbox.

 

[lespaul]

what is the exact formula you entered in the control box? What is the SQL of the source? Do you have fields named [qty] and [price] in the query/table?

Leslie