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

Save a sum from a form to a table

P: 46
Hi,

I'm using Access 2007 and have a form that calculates a sum from the input of 2 other boxes on the form( sheets*SqFtpersheet), I then need this sum needs to be saved to an inventory table. I know the best way would be to save the input of the boxes to the table and then do the calculation in queries and reports when I need it. The problem is that both of these inputs are not part of the table and I am hoping there is a way to accomplish this without changing the table. Is there a way to do it?

thanks,
Jeff
Apr 10 '08 #1
Share this Question
Share on Google+
1 Reply


P: 68
use an insert query for the place in the table(for the current record) that you want to put the value:
Insert InTo [Table Name] (fieldname1,FieldName2, ..) & _
" Values (formfieldname, formfieldname)"
Apr 10 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.