Using Nz()

Local time
Today, 01:11
Joined
Feb 25, 2008
Messages
410
If I use Trim(Nz([Service State],""))
as the Update To value in an update query then:

If the value of [Service State] = "Ca " then it will return "Ca"
or if the value of [Service State] is null then it will return a zls.. right?

Am I correct to assume this?
 
yes, that is correct.
 

Users who are viewing this thread

Back
Top Bottom