B
bevank
Guest
I' m new to MS Access. Pardon my ignorance.
I have a table with four columns: part number; part description; list price; and discount code, eg., "A", "B", "C". The "A" discount is 0.18, the "B" discount is 0.21, and so on. Each part is assigned a discount code. I want to calculate the actual discounted price for each item. I have created a query which does the math, but the results are displayed in different columns of the query.
First column--BTP-A: IIf([TRANSFER PRICE INDEX]![disc]="A",[TRANSFER PRICE INDEX]![price]*0.18)
Second column--BTP-B: IIf([TRANSFER PRICE INDEX]![disc]="B",[TRANSFER PRICE INDEX]![price]*0.21)
I need to have the results displayed in the same column of the query for each part.
All suggestions will be greatly appreciated! Thanx.
I have a table with four columns: part number; part description; list price; and discount code, eg., "A", "B", "C". The "A" discount is 0.18, the "B" discount is 0.21, and so on. Each part is assigned a discount code. I want to calculate the actual discounted price for each item. I have created a query which does the math, but the results are displayed in different columns of the query.
First column--BTP-A: IIf([TRANSFER PRICE INDEX]![disc]="A",[TRANSFER PRICE INDEX]![price]*0.18)
Second column--BTP-B: IIf([TRANSFER PRICE INDEX]![disc]="B",[TRANSFER PRICE INDEX]![price]*0.21)
I need to have the results displayed in the same column of the query for each part.
All suggestions will be greatly appreciated! Thanx.