Prev: GET ONLY LAST DATE
Next: Turn off Auto Fill In???
From: src on 16 Jun 2006 09:51
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.
From: Jeff Boyce on 16 Jun 2006 13:20
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" <src(a)discussions.microsoft.com> wrote in message
news:54AA5112-7742-4165-A21C-8F31911AC0A5(a)microsoft.com...
> 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.


From: src on 20 Jun 2006 17:11
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.


"Jeff Boyce" wrote:

> 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" <src(a)discussions.microsoft.com> wrote in message
> news:54AA5112-7742-4165-A21C-8F31911AC0A5(a)microsoft.com...
> > 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.
>
>
>
From: Jeff Boyce on 21 Jun 2006 12:37
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


"src" <src(a)discussions.microsoft.com> wrote in message
news:56AF40B3-B9A9-4E8A-B6F0-DEDB62BD756E(a)microsoft.com...
>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.
>
>
> "Jeff Boyce" wrote:
>
>> 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" <src(a)discussions.microsoft.com> wrote in message
>> news:54AA5112-7742-4165-A21C-8F31911AC0A5(a)microsoft.com...
>> > 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.
>>
>>
>>


 | 
Pages: 1
Prev: GET ONLY LAST DATE
Next: Turn off Auto Fill In???