user3508824 user3508824 - 5 months ago 5
SQL Question

I am trying to add a new column in Access called Reduced Price that reduces the ProductUnitPrice column by 10%

SELECT ProductID, ProductDescription, ProductUnitsOnHand, ProductUnitPrice
FROM tblProduct
ALTER tblProduct
ADD COLUMN Reduced Price NUMBER DEFAULT 0


This is what I have been able to figure out so far.

Answer

Are you trying to add a permanent column to an existing table, or just output an additional column with your results? I'm going to guess the latter. If I'm right, then try this:

SELECT ProductID, ProductDescription, ProductUnitsOnHand,
       ProductUnitPrice, (ProductUnitPrice * .9) as [Reduced Price]
FROM tblProduct
Comments