TOTAL

[RICHARD BROMBERG]

Using Access 2000, I have a table called tblAccounts
The number of entries in this table can increase or decrease.

I also have a form where I use a Combo box to locate any of the entries
using the Account Number as the primary key so I can update the Amount field
for any entry in the table.

After I update the amount field, I want to display the grand total of the
amount fields.

Assuming the table is called "accounts" how do I total up the amount fields.

thanks from a newbie

[Wayne Gillespie]

Re: TOTAL

On Tue, 05 Dec 2006 14:36:53 GMT, "RICHARD BROMBERG" <noreply@att.ne twrote:

>Using Access 2000, I have a table called tblAccounts
>The number of entries in this table can increase or decrease.
>
>I also have a form where I use a Combo box to locate any of the entries
>using the Account Number as the primary key so I can update the Amount field
>for any entry in the table.
>
>After I update the amount field, I want to display the grand total of the
>amount fields.
>
>Assuming the table is called "accounts" how do I total up the amount fields.
>
>thanks from a newbie
>

DSum("amount"," accounts")


Wayne Gillespie
Gosford NSW Australia