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

Increment Total on Second Table from Form

P: n/a
I have two one-to-many related tables, "Jobs" and "Charges". Jobs has a
primary key called "Jobnum". Charges has a number of records relating
to each Jobnum; these records include information about specific
charges, including the amount, called "Charge". Jobs has a field called
"Totcharge", which is the sum of Charges for all Charges in each Jobnum.

I have designed a form to input a new Charge record. When I click the
command button after having input the data, I would like to increment
Totcharge on the Jobnum record of Jobs by the amount of Charge.

What is the simplest way of doing this in Access?

Thanks
Paul

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Paul Gurwitz <pg******@renaiss.com> wrote in message news:<hZ******************@newsread3.news.atl.eart hlink.net>...
I have two one-to-many related tables, "Jobs" and "Charges". Jobs has a
primary key called "Jobnum". Charges has a number of records relating
to each Jobnum; these records include information about specific
charges, including the amount, called "Charge". Jobs has a field called
"Totcharge", which is the sum of Charges for all Charges in each Jobnum.

I have designed a form to input a new Charge record. When I click the
command button after having input the data, I would like to increment
Totcharge on the Jobnum record of Jobs by the amount of Charge.

What is the simplest way of doing this in Access?

Thanks
Paul


put an unbound control on your main form that does a DSUM of the subform records?
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.