IIF statement in MS Access Queries don't return false argument

Dear all,

I am working on a query,

IIf([dbo_loc]![POSTALCODE]=[TRHazardZones]![POSTALCODE],[TRHazardZones]![TRZONES],'LOW')

where it will match Postalcodes from two tables, when it matches it
returns the zones but if the condition don't match it won't return
"LOW" (not even the row).

Regsrds,
Shital

re: IIF statement in MS Access Queries don't return false argument

If it's not returning the row, how can you tell if that
the IIF is not 'LOW'?

Is the IIF part of the query criteria? (or part of a Join?)

Why aren't you getting the row?

(david)



"rock" <khandar@gmail.com> wrote in message
news:1150270775.744854.180920@y41g2000cwy.googlegr oups.com...[color=blue]
> Dear all,
>
> I am working on a query,
>
> IIf([dbo_loc]![POSTALCODE]=[TRHazardZones]![POSTALCODE],[TRHazardZones]![TRZONES],'LOW')
>
> where it will match Postalcodes from two tables, when it matches it
> returns the zones but if the condition don't match it won't return
> "LOW" (not even the row).
>
> Regsrds,
> Shital
>[/color]

re: IIF statement in MS Access Queries don't return false argument

I agree with David. It sounds like the join between the two tables is
saying "select all that match and no others".

Consequently you will never encounter the "LOW" condition. They will
always match.

Ron