i want item price to be selected from price table based on the size of quantity ordered
=IIf([QTY]<=4,(DLookUp(" item_price","Price Table","[Price Table]![item_code]=" & [code] & "And [Price Table]![item_size]=10")),(IIf([QTY]<=15,(DLookUp(" item_price","Price Table","[Price Table]![item_code]=" & [code] & "And [Price Table]![item_size]=20")),(DLookUp(" item_price","Price Table","[Price Table]![item_code]=" & [code] & "And [Price Table]![item_size]=30")))))
worked for me but it is too long ca someone simplify.