Cummulative

[Alimbilo]

How can I calculate a cummulative of:

A = 4
B = 5
C = 8

 

[John W. Vinson]

How can I calculate a cummulative of:

A = 4
B = 5
C = 8

Perhaps you could explain the context and what you mean by a "cummulative" - a
cumulative sum perhaps? Are these VBA variables, table fields, records in a
table? Are you using a Form or a Report or what?

 

[Alimbilo]

They are table fields.
I tried to use this in the VBA code but it did not work.
D= Sum(A*B*C) is giving me an error.

 

[John W. Vinson]

They are table fields.
I tried to use this in the VBA code but it did not work.
D= Sum(A*B*C) is giving me an error.

Again:

What are you trying to accomplish?

What is the "cummulative" of 4, 5, and 8?

Where do you want to calculate it?

Where do you want to show it?

Alimbilo, *you* can see your computer. You understand your project. We cannot
and do not. You'll need to post enough information that someone unfamiliar
with what you're doing will have a chance to help.

The Sum() function in SQL sums values across multiple records. It is not a
valid function in VBA. You also cannot directly refer to table fieldnames in
VBA; you need to either use a Form or open a Recordset.