Performing math in VB from an Access Form

I

Isis

I have an access Form open - I have a button on the form and in the Click
Event I want to perform some math using the values of fields showing in the
form - so for instance on of the fields is 'Price' one of the fields is
'Shipping' I want to add the amount in 'Price' to the amount in 'Shipping'
and place it in a String for use elsewhere.

Can this be done from a VB statement ?

Thanks for any help
 
F

fredg

I have an access Form open - I have a button on the form and in the Click
Event I want to perform some math using the values of fields showing in the
form - so for instance on of the fields is 'Price' one of the fields is
'Shipping' I want to add the amount in 'Price' to the amount in 'Shipping'
and place it in a String for use elsewhere.

Can this be done from a VB statement ?

Thanks for any help
Click to expand...

Place it in a string? Are you sure?
Dim strString as String
strString = CStr(Nz([Price],0) + Nz([Shipping],0))
 
I

Isis

I have an access Form open - I have a button on the form and in the
Click Event I want to perform some math using the values of fields
showing in the form - so for instance on of the fields is 'Price' one
of the fields is 'Shipping' I want to add the amount in 'Price' to
the amount in 'Shipping' and place it in a String for use elsewhere.

Can this be done from a VB statement ?

Thanks for any help
Click to expand...

Place it in a string? Are you sure?
Dim strString as String
strString = CStr(Nz([Price],0) + Nz([Shipping],0))
Click to expand...

Thanks for the answer Fred - I am using a string because it is going to
be pasted into an email eventually.

What does the 'Nz' bit mean and what is the placeholder '0' for ?

Thanks again
 
F

fredg

I have an access Form open - I have a button on the form and in the
Click Event I want to perform some math using the values of fields
showing in the form - so for instance on of the fields is 'Price' one
of the fields is 'Shipping' I want to add the amount in 'Price' to
the amount in 'Shipping' and place it in a String for use elsewhere.

Can this be done from a VB statement ?

Thanks for any help
Click to expand...

Place it in a string? Are you sure?
Dim strString as String
strString = CStr(Nz([Price],0) + Nz([Shipping],0))
Click to expand...

Thanks for the answer Fred - I am using a string because it is going to
be pasted into an email eventually.

What does the 'Nz' bit mean and what is the placeholder '0' for ?

Thanks again
Click to expand...

Open any code window and click on Help.
Type NZ in the index window and read what VBA help has to say.
 
Top