total amount

[Jeroen van vliet]

Hello,

im using visual basic 6.0 and i made an form where to insert
names,street and an amount of money into an access database. Well every time
when i insert an amount of money, the amount has to be added to the previous
total amount from this name. I
want to be able to count a total amount, but also separately for each name.
How is this possible?

Jeroen

[Pieter Linden]

"Jeroen van vliet" <in**@educationalstays.com> wrote in message news:<bj**********@reader11.wxs.nl>...

Hello,

im using visual basic 6.0 and i made an form where to insert
names,street and an amount of money into an access database. Well every time
when i insert an amount of money, the amount has to be added to the previous
total amount from this name. I
want to be able to count a total amount, but also separately for each name.
How is this possible?

Jeroen

easiest way is to add the amounts to a child table of the Person
table. Then link the two and add the individual records. Then you
can just use a summary query, or use the DSUM function from Access
(just declare the Access library, and you should be ready to roll.)