If statement

[lwarren1968]

3 fields involved in this question! I need to write query/statement where IF MAP_Enable = "Y" then return pricing for both Map_Price and MSRP_Price. If "N" then both MAP_Price and MSRP_Price should be blank.

MAP_ENABLE MAP_PRICE MSRP_PRICE
Y 1.99 1.99

Any help would be much appreciated. Thanks.

 

[plog]

What have you tried? I mean a simple Iif statement is all you need.

https://www.techonthenet.com/access/functions/advanced/iif.php


And never assume things about your data (especially when using the improper type for values). What happens if Map_Enable is neither 'Y' nor 'N'?

 

[lwarren1968]

Self taught, sorry. But, yes there is a possibility that the MAP_Enable could be blank.

 

[plog]

Nothing to be sorry for, well except not answering my questions.

What have you tried? Post code.

What occurs with those null values?

 

[lwarren1968]

It works, thanks for the link.

 

[lwarren1968]

I did one for each using only "Y" as you suggested. Thanks again.

msrp_price_new: IIf([map_enabled]="Y",[msrp_price])