Nz function - recurring syntax error (comma)

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Here's my Nz problem:

In my query design, I have 4 tables joined together in a
chain, with all table-joins set to #1 (i.e., rows where
joined fields from both tables are equal).

The Nz function does not seem to be working in any field.
For example, in my "PM ID" field (where I want to convert
null values to zeros), I have placed the following in a
Field box in design view:

Nz([PM ID],0)

I keep getting the following error message: "Syntax error
(comma) in query expression 'Properties.[Nz([PM ID],0)]'.

FWIW, I'm running Access 2002 in XP.

Any help would be appreciated!
 
In the Field box insert

xx: Nz([PM ID],0)

XX is the field-name of the result of the NZ function.

Frank
 
Back
Top