Syntax for is null

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Syntax for is null

Post by matthewR »

I need to say in a query - IIF([Keystone] is null, [Plan Code], [keystone]). Can't seem to get the right syntax for is null
Top
User avatar
HansV
Administrator
Posts: 78485
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Syntax for is null

Post by HansV »

Try

Nz([Keystone],[Plan Code])
Best wishes,
Hans
Top

Return to “Access/SQL and other database applications”