coalesce alternative in Access SQL

Access supports the Nz function and allows you to use it in a query. Note though that Nz is the same as the T-SQL ISNULL function. It can not take an arbitrary number of parameters like COALESCE can.

Looks like I can just use:

SELECT ProductId, Nz(Price, 0)
FROM Products

Seems to be working just fine.

If it's in an Access query, you can try this:

"Price = IIf([Price] Is Null,0,[Price])"