By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

TOTAL

P: n/a
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
Dec 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 05 Dec 2006 14:36:53 GMT, "RICHARD BROMBERG" <no*****@att.netwrote:
>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
Dec 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.