NZ() recognition in Access

[Delboy14]

Crystal 8.5 Proffesional edition, Access 2002

I have a problem I am using the nz() function in an Access table, this allows you to insert a value if the query has null values (e.g. zero instead of null records). The problem I am having is Crystal will not use the query because it does not recognise the nz() feature does anyone know a fix for this? (dont send to Crystal help it is s*$t and I spent four hours on the phone about a fault the last time)

 

[bferguson]

Use ODBC to acess your database, and then you can use use SQL expressions, which has an IfNull function available.

 

[Delboy14]

Thanks I can use that but for portability, it is best if I can keep my queries in Access, does anyone know if there is a way I can use the NZ() option of Access without getting an error in Crystal Reports?