Sum of values in a continuous form

T

Travis

I've got a continuous (sub)form based on a query.

It looks like this...

< Investment_name1 > < cost_base1 > < current_value1 >
< Investment_name2 > < cost_base2 > < current_value2 >
< Investment_name3 > < cost_base3 > < current_value3 >
< Investment_name4 > < cost_base4 > < current_value4 >
< Investment_name5 > < cost_base5 > < current_value5 >

Plus other fields which aren't relevant to this question.

I want a total at the bottom of the form, sum of all cost bases, sum of
all current values.

I know how to add together values in a NON continuous form, but not
sure how to go about doing it with a continuous form.

I tried to build the expression = sum ( [fieldname] ) and placed it in
the footer, but the box is blank...

Travis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access form continuous 1
Paragraph numbering in Word 1
DLookup in Continuous form 0
Total Detail on Continuous Form 5
Form with a Continuous subform 1
Continuous Forms - Sum of Values 5
Instant Totals on Continuous Forms 0
Continuous Form: Change the color of one row 1

Top