AND in query expression

[Garry]

Hi all

Can someone tell me where I am going wrong with the following query
expression

Rate: IIf([X]=25 And [Y]=1 And [Z]=1,"Red","Blue")

Getting error message

Thanks, Garry

 

[Rick B]

What does the error say?

 

[Garry]

In the select query window it just says Rate: #Error

What does the error say?

--
Rick B

Hi all

Can someone tell me where I am going wrong with the following query
expression

Rate: IIf([X]=25 And [Y]=1 And [Z]=1,"Red","Blue")

Getting error message

Thanks, Garry

 

[OfficeDev18 via AccessMonster.com]

what's the error msg?

Hi all

Can someone tell me where I am going wrong with the following query
expression

Rate: IIf([X]=25 And [Y]=1 And [Z]=1,"Red","Blue")

Getting error message

Thanks, Garry

 

[OfficeDev18 via AccessMonster.com]

Seems to me Rate should be numeric, but you're feeding it string values.

Sam

what's the error msg?

Hi all

[quoted text clipped - 6 lines]

Thanks, Garry

 

[Garry]

For some reason if I replace the FIELD Z and TABLE CLIENT in the query
with Z : 1 it works fine

Seems to me Rate should be numeric, but you're feeding it string values.

Sam

what's the error msg?

Hi all

[quoted text clipped - 6 lines]

Thanks, Garry