Trying to create a subquery for a table in Access.
I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the table, and don't want to create another table with that field. How can I create this in a subquery.
I tried this code, but it didn't recognize the Discount_Percent field I created.
SELECT [Sales_2001-2010].* ,[Sales_2001-2010].[Discount_Amount]/[Sales_2001-2010].[Sales_Amount] AS Disount_Percent FROM [Sales_2001-2010] WHERE ((([sales_2001-2010].Sales_Amount)>1000))
The table has four fields Customer_Name Sales_Amount Discount_Amount Date
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!