hELLO
I have create a simular database. What i did was build one query and then had and if statement which said:
Net Amount:iif([Total No Items]>5,[Total no Items]*[Price 2],[Total no Items]*[Price 1])
The above is a condensed version of the iif statment has mine had upto 10 different...