Calculations from Form Fields

  • Thread starter Thread starter FpwL1399
  • Start date Start date
F

FpwL1399

Hello, I have a form, and on that form is a button that will let the
operator put in a new entry. The thing is that I want this button to
also take the difference of two fields on that form and enter it into a
third field. Is there any way to do this in VB?

I have Pre, Post, and Delta. I want Delta = Post - Pre.
 
Well I've gotten it to subtract automatically but the value isn't being
applied into the table.

I set the Control Source to =[Post]-
, but is there a way to make
that also be the delta value in the table?
 
FpwL1399 said:
Hello, I have a form, and on that form is a button that will let the
operator put in a new entry. The thing is that I want this button to
also take the difference of two fields on that form and enter it into a
third field. Is there any way to do this in VB?

I have Pre, Post, and Delta. I want Delta = Post - Pre.
Click to expand...


Calculated values should not be stored in a table. Just use
an unbound text box with the expression:

== Post - Pre
 
Sorry to sound like a child, I need the value to be placed in a table
to be exported to another program that I am using for process control
in my facility.
 
FpwL1399 said:
Sorry to sound like a child, I need the value to be placed in a table
to be exported to another program that I am using for process control
in my facility.
Click to expand...

Then put the calculation in a query and export the query instead of the
table.
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
Back
Top