Tony Septav
iggy at nanaimo.ark.com
Sat Jun 4 10:13:44 CDT 2011
Hey Charlotte Thanks. No I got that what I dont' understand is why Msgbox Me!InvoiceAmount + Nz(Me!TotalInvoice,0) it displays 1000 Gives me the correct total rather then an error message. Charlotte Foust wrote: >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 >> >> >> >> >>