Calculation not working

[navi95]

Hi Guys,

So im trying to make a simple calculation in my order form which is in datasheet mode (if that makes any difference)
So its very simple stuff, my goal is (qty * (item price + extra fee))

So "total preise" works fine, the code is: =[Preis]+[Extra Price]
so for the next but, to multiply by the qty i have inserted: =[total preis]*[Anzahl] but I get this weird answer, as seen in the screenshot next to Text14

I wanted to be able to see the break down of the pricing in the form, thats why i didnt use (qty * (item price + extra fee))...I did try using this too, i got the same weird answer.

I must be overlooking something tiny...any thoughts?

Oh....AND....i would like to add a running total on the side somewhere, this form is actually a subform, so I can I add the running total on the main form?

thanks

 

[sneuberg]

What do you see if you just put

=[Anzahl]

in Text14?

 

[MarkK]

FWIW, I would be tempted to do this math in the query that drives the form rather than in the form itself.

 

[navi95]

Hi guys,

I actually solved this by accident by creating an aggregate query, which grouped the data and gave me the some totals as well so that worked out rather nicely

Thanks for the responses