Performing math in VB from an Access Form

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

On 13 Mar 2006 01:05:05 GMT, Isis wrote:

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

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



--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

fredg wrote in
:

On 13 Mar 2006 01:05:05 GMT, Isis wrote:

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

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




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

On 13 Mar 2006 12:45:11 GMT, Isis wrote:

fredg wrote in
:

On 13 Mar 2006 01:05:05 GMT, Isis wrote:

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

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


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

Open any code window and click on Help.
Type NZ in the index window and read what VBA help has to say.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail