coalesce alternative in Access SQL
Solution 1:
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.
Solution 2:
If it's in an Access query, you can try this:
"Price = IIf([Price] Is Null,0,[Price])"