A.D. Tejpal, hanks for your help. The db you suggested works very well. I can
start from there.
But I think it doesn't solve the problem if I have more than one account in the
same table (as far as I know). If It does, I didn't got there... need more
help. :)
I got something using:
RepairAcumulado: Val(DSoma("ValRepair";"A 0020 Repair by Year";"Year <= " &
[Year] & " and EQPCOD = '" & [EQPCOD] & "'")).
But It is very slow calculating all records (more than 3000, ex: 300 EQP
repaired during 10 years).
I think your solution would be the ideal if made to have more than one
"account" for bank db or "equipment" for a production db.
Thanks again.
Paulo
----- Mensagem original -----
De: A.D.Tejpal
Para: [email protected]
Enviado: ter�a-feira, 22 de Mar�o de 2005 19:25
Assunto: Re: [ms_access] Sum of values
Paulo,
You might be able to get some working ideas from my sample db named
RunningAccount, available at Rogers Access Library (other developers library).
Link -
http://www.rogersaccesslibrary.com
Best wishes,
A.D.Tejpal
--------------
----- Original Message -----
From: Paulo Ferreira
To: [email protected]
Sent: Tuesday, March 22, 2005 21:41
Subject: [ms_access] Sum of values
Hello;
I'm new to this group and I need help with a problem that happens to me a
lot and still don't have a solution.
I need to have a column in a query that sums or acumulates values of the
previous records. For example a machine (M001) works 1000 hours in 2001. The
acumulate value is 1000, the same machine works 1600 in 2002, te acumulated
value turns to 2600 is this same record.
Example:
Machine Year Year Production Sum
100 2001 14.567,00 21.227,00
100 2002 16.388,00 37.615,00
100 2003 16.169,00 53.784,00
200 2001 6.660,00 6.660,00
200 2002 6.972,00 13.632,00
200 2003 5.934,00 19.566,00
If it a bank acount (don't know if it is the same technic
Account Date Kind of movement Debit Credit Value
111 01-Jan deposit 500 500
111 02-Jan deposit 100 600
111 03-Jan payment 50 550
111 04-Jan payment 10 540
130 01-Jan deposit 2 2
130 01-Jan deposit 1 3
130 02-Jan deposit 1 4
130 03-Jan payment 1 3
130 04-Jan payment 1 2
130 01-Jan deposit 3 5
Hope earing from you
Thanks
Paulo Ferreira
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
