forms + summing

[kevcar40]

hi
i have a continuous form that conains data about a product
i have the product price and the quantity available
i have the calculated the total value for each product (textbox total)
i now want to sum all the totals to give me a overall stock value

i would also like the total to update as the quantites change

i have tried Dsum but this seems to be hit and miss

any ideas?

thanks


kevin

 

[Guest]

Hi Kevin,

You might want to try this tutorial:

Displaying Subtotals and a Grand Total on a Form
That Displays a One-to-Many Relationship
http://www.access.qbuilt.com/html/subtotals.html

The tutorial is written for a subform that is in datasheet mode. I haven't
specifically tested it with a continuous form, although I see no technical
reason that it wouldn't work.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________