Re: Performing math in VB from an Access Form

fredg <fgutkind@xxxxxxxxxxxxxxx> wrote in
news:fhts04qajxgs.1jatwhc9xe005.dlg@xxxxxxxxxx:

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
.

Loading