[AccessD] Nz and Val

As far as I recall, Nz returns a string, so the display 800900 is the
concatenation of two strings. You have to convert the result with the Val()
function to make it work properly in calculation.
Charlotte Foust


On Sat, Jun 4, 2011 at 7:49 AM, Tony Septav <iggy at nanaimo.ark.com> wrote:

> Hey All
> Spent the last couple of hours testing the problem. I  very rarely use Nz.
> This doesn't work
>
> A)If Me!InvoiceAmount + Nz(Me!TotalInvoice, 0) > Nz(Me!Budget, 0) Then
> ..... display Yes/No message
> End If
>
> But this does
> B) If Me!InvoiceAmount + val(Nz(Me!TotalInvoice, 0)) > val(Nz(Me!Budget,
> 0)) Then
> ..... display Yes/No message
> End If
>
> And it (the Duh the light finally came on) makes sense TotalInvoice and
> Budget are numbers pulled from a ComboBox. If they are null display a zero,
> otherwise display the number which is text not numeric.
>
> Just curious again, what I don't understand is if I do
> 1. Msgbox Me!InvoiceAmount + Nz(Me!TotalInvoice,0) it displays 1000
> 2. Msgbox Nz(Me!TotalInvoice,0)+ Nz(Me!TotalInvoice,0) it displays 800900
> With 1. The total is correct but I would have thought I would have gotten
> an error message instead when trying to add a value to text??  Which is why
> A) above doesn't work.
>
> Thanks Again
>
>>
>>
>>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>