Tuesday, October 21, 2008

Microsoft Access version of Coalesce

Ever need to use Access for something only to learn that the handy coalesce function doesn't exist?

Turns out Access has a function by a different name that performs a similar though slightly more limited function.
Syntax: Nz(value, valueifnull)

Read about it here.

No comments: