A very Simple Thing ADDITION

[mxdcy]

i have a form that runs a query and gives a result of cars that have being renterd filterd by model

and stupid i can't find a way to add a sum to tha form of all the amounts

any ideas

pls help

 

[danvlas]

An unbound textbox with the formula:
=Sum([FieldHoldingAmounts])
will do
If the amounts are calculated, the calculation will be:
=Sum(FullExpression)

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[mxdcy]

still gave me an #error

the think is that there is a filter when the form is proccesed

full expresion you meen to enter the complete epresion like

form.car rentald statistic.amount
??


thanks for your previous answer

 

[danvlas]

No...What I mean is:
1. If [Amount] comes from the table/query that provides data to the form, then the formula is:
=Sum([Amount])

2. If [Amount] is a calculated text box on the form and has a formula like:
=[Quantity] * [Price]
then the formula for the sum should be:

=Sum([Quantity] * [Price])

Mind the names of the fields. Place the actual names in the brackets.

HTH

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[mxdcy]

Right that should work or at least thats what the manual says


but still i have the error

anyway thanks alot for your anwsers i will try to do aditional queries and an extra popup form that takes variables from the previous one to overcome the problem