Calculations from Form Fields

[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.

 

[FpwL1399]

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?

 

[Marshall Barton]

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.

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

== Post - Pre

 

[FpwL1399]

But I want it in a table.

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

== Post - Pre

 

[FpwL1399]

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.

 

[Rick Brandt]

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.

Then put the calculation in a query and export the query instead of the
table.

 

[FpwL1399]

Yep...I just figured that out about 10 minutes ago. Thanks for your
help.

 

[eos]

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

 

[eos]

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

 

[eos]

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

 

[eos]

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

 

[eos]

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

 

[eos]

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

 

[eos]

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