IIF function for 2 criteria

[Erictsang]

Dear all

I need some help for the IIF statement


I have a sale record that collected for July and August

I have decided to offer an Early bird offer to those who purchase in July

I have a table recorded the following

Month | client | Purchase (1=Yes/0 =No)
1 July | Eric | 1
5 July | Bertha |1
3 Aug | Paul |1



I have already applied Priceurchase=1,HK$100,0)

But how i can make that like for those who purchase before 1 August Price = Price = 95?

Thanks
Eric

[ranman256]

1.
the better answer is , this should be done via the query and the tInventory table and a tDiscount table.
where the tDiscount value is given if date < 8/1/yy ,

ITEMID, PRICE, DISCOUNTPRICE
123, 100, 95

then the query reads the tDiscount date, and converts tInventory .price to the tInventory .DISCOUNTPRICE.

2.
THE EASIER WAY :
run an update AT the purchase, (or some point)
to modify the purchase table to the discount price. UPDATE tPurchase set [price]=95 where [PurchDate]<#8/1/17#
no IIF needed.

3. But to use IIF:
IIF([PurchDate]<#8/1/17#,100,95)

[Erictsang]

June

I perfect the option of
3. But to use IIF:
IIF([PurchDate]<#8/1/17#,100,95)


My structure is

[purchasedate]
[item1] = input for user is 1 or null
[item2] = input for user is 1 or null

So if i use your suggestion

IIF([PurchDate]<#8/1/17#,[item1]=1, 100,95)??

Eric

[June7]

Month is a reserved word. Should not use reserved words as names for anything.

You are saving month name in field? Apply discount only to month of July - not Jan thru Jun?

95 and 100 are the only prices for every purchase?

Exactly what is table structure? Posts 1 and 3 seem contradictory. Are there actually 2 tables involved?