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

qty should be Quantity

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

Aggregate Functions, such as Sum(), have to be run against the underlying Fields, not against the Controls displaying the Fields.

As Peter said, you need to replace Qty with Quantity and 'Price' with whatever is the Control Source for the 'Unit Price' Textbox. Your image only shows 'ProductU.' Possibly ProductUntiPrice?

Linq ;0)>

Thanks for reply

So if I understand correctly, if I use =sum([fieldA] * [fieldB]) rather than just [fieldA] * [fieldB] my approach is slightly different? I think I now understand why my now works (see attached)

My example "text boxes" use qty & quantity, qty is the the name of the text box & quantity is the control sauce of the text box.

Yes. Multiplying the contents of two Controls, in the same, Current Record, can be done using

Me.txtFieldA * Me.txtFieldB

because they are in the same Record and thus available. You cannot mistake which Record you're talking about; it's the Current Record.

But when you're using any of the Aggregate Functions, such as Sun(), you have to use the names of the actual Fields as they appear in the underlying Table. That's because in using Sum(), you're doing calculations that involve Multiple Records, not just a Single Record.

Linq ;0)>

Thanks Missingling,

Simple & pretty obvious well explianed in such concise detail.

I like it here.

Glad we could help!

Welcome to the site!

Linq ;0)>