Hi All,

I have created an input form for a quote/invoice system, it's a continuous form with what I see as simple calcs within it BUT...it's never that simple. Basically, the form cals the value & qty per line & thats fine, but I cannot get it to ttal all the lines as a "sum".

I've attached images showing what i'm doing (wrong i guess) but thought this would work.

When I have looked at other sample DB's this does appear to be how it's done, so where have I gone wrong?

Any help appreciated

cheers Peter,

Both where wrong but you could not see that from the image uploaded. Sure I tried that yesterday along with 1000 other ways incl queries and the like.

But sorted thanks