RossWindows
Que?
- 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?
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?