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]

Re: total amount

"Jeroen van vliet" <info@education alstays.com> wrote in message news:<bj8na3$bj p$1@reader11.wx s.nl>...[color=blue]
> 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[/color]

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.)