Empty to Null

Hello,

Is there any way to convert a empty field to Null?

Thank you,

Kazumi

Tips and Tricks

Accepted answers

IIF(IsEmpty([field]),Null(),[field])

That should do the trick.

Cheers,

Mark

All comments

IIF(IsEmpty([field]),Null(),[field])

That should do the trick.

Cheers,

Mark

Thank you! It worked!

Sincerely,

Kazumi

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703