DSUM or running total

[src]

Hi all, I am an extreme novus with Access. I read every DSUM, running total
subject on this board and cant figure out my challenge.

Here it is: field1-ssn, field2=amt witheld field3=amt pd. field4=balance

I just want to calculate in a very large database, the balance by ssn, and
a running total. How do I do this.

Any help would be greatly appreciated.

 

[Jeff Boyce]

I'm not sure you and I use the terms to mean the same things.

First, what's your underlying data structure? Is that the [ssn],
[amt_withheld], [amt_pd], [balance]? If so, your data structure could
benefit from simplification ... you don't need to store a balance if you
have the values needed to calculate the balance (and there are good reasons
NOT to -- synchronization is one).

Second, what do you mean by "running total"?

Can you describe the calculation you want to do as an equation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[src]

I am using a query to calculate the "balance" but then I want a running
total. So I can see all the transactions it takes to come up with the total
balance. see below for example.
ssn amt w/held amt pd bal.
running total
1111 10.00 5.00 5.00 (calculated)
5.00
2222 50.00 75.00 <25.00> ""
<20.00>
3333 125.00 50.00 75.00 ""
55.00
etc..
I hope that helps.

I'm not sure you and I use the terms to mean the same things.

First, what's your underlying data structure? Is that the [ssn],
[amt_withheld], [amt_pd], [balance]? If so, your data structure could
benefit from simplification ... you don't need to store a balance if you
have the values needed to calculate the balance (and there are good reasons
NOT to -- synchronization is one).

Second, what do you mean by "running total"?

Can you describe the calculation you want to do as an equation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi all, I am an extreme novus with Access. I read every DSUM, running
total
subject on this board and cant figure out my challenge.

Here it is: field1-ssn, field2=amt witheld field3=amt pd. field4=balance

I just want to calculate in a very large database, the balance by ssn,
and
a running total. How do I do this.

Any help would be greatly appreciated.

 

[Jeff Boyce]

Consider using a report. You can use a "running sum" setting on a control
in the report, and base the report on your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am using a query to calculate the "balance" but then I want a running
total. So I can see all the transactions it takes to come up with the
total
balance. see below for example.
ssn amt w/held amt pd bal.
running total
1111 10.00 5.00 5.00 (calculated)
5.00
2222 50.00 75.00 <25.00> ""
<20.00>
3333 125.00 50.00 75.00 ""
55.00
etc..
I hope that helps.

I'm not sure you and I use the terms to mean the same things.

First, what's your underlying data structure? Is that the [ssn],
[amt_withheld], [amt_pd], [balance]? If so, your data structure could
benefit from simplification ... you don't need to store a balance if you
have the values needed to calculate the balance (and there are good
reasons
NOT to -- synchronization is one).

Second, what do you mean by "running total"?

Can you describe the calculation you want to do as an equation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi all, I am an extreme novus with Access. I read every DSUM, running
total
subject on this board and cant figure out my challenge.

Here it is: field1-ssn, field2=amt witheld field3=amt pd.
field4=balance

I just want to calculate in a very large database, the balance by ssn,
and
a running total. How do I do this.

Any help would be greatly appreciated.