Sub Form calculation on main form

[Keiath]

I have a order system,

On the purchase order form I have a Sub form for the orders.

Each line has a Line price ie:- ( qty*Price=total) I want to display the total order price outside the sub form. Whic I have done but it only adds the first line of the order, how do I get it to add all lines (there could be 2 or 5 order lines) to give me a grand total

Thanks

 

[Alansidman]

Look at using the DSUM function. I think that you will need to put it in the footer of your main form in an unbound text box.

http://www.techonthenet.com/access/functions/domain/dsum.php

 

[Keiath]

Look at using the DSUM function. I think that you will need to put it in the footer of your main form in an unbound text box.



Thanks for that

This might be a tat beyond me... kinda new to this stuff, but I'll give it a try!!

 

[Alansidman]

Give it a shot. Post back with your successes and issues. Lots of good people here ready to help.

 

[Alansidman]

Got your PM. Suggest you post to the forum directly so that everyone is available to help. Now, suggest you post your database to the forum so that we can look at it directly. Run a compact and repair and dummy up any confidential information before uploading. Scroll down and click on manage attachments.