So, I'm pretty new to Access, and have been teaching myself as I go along. I am also new to forums to I apologize if I don't explain myself well.
I am trying to create a query that will bring up a specific price of a specific style based on the qty on the order. Eventually, I'd like to create a form where someone can enter the style number and the qty on the order, and then it would bring up the price. The table is currently layed out as such:
Style -- Desc -- Price_1-99 -- Price_100-999 -- Price_1000-4999 -- Price_5000-14999 -- Price_15000-19999 -- Price_20000+
AFR701 -- SS Tee -- $11.10 -- $5.90 -- $5.55 -- $5.43 -- $5.25 -- $5.06
AFR801 -- short -- $13.60 -- $7.20 -- $6.80 -- $6.57 -- $6.35 -- $6.11
AFR201 -- pants -- $11.60 -- $6.20 -- $5.80 -- $5.66 -- $5.46 -- $5.27
What I would like is if the order is 15 units, for style AFR701, for the query to bring up the $11.10 price. Or, if the order is 155000, to bring up the $5.25 price. Is this possible? Thank you.
I am trying to create a query that will bring up a specific price of a specific style based on the qty on the order. Eventually, I'd like to create a form where someone can enter the style number and the qty on the order, and then it would bring up the price. The table is currently layed out as such:
Style -- Desc -- Price_1-99 -- Price_100-999 -- Price_1000-4999 -- Price_5000-14999 -- Price_15000-19999 -- Price_20000+
AFR701 -- SS Tee -- $11.10 -- $5.90 -- $5.55 -- $5.43 -- $5.25 -- $5.06
AFR801 -- short -- $13.60 -- $7.20 -- $6.80 -- $6.57 -- $6.35 -- $6.11
AFR201 -- pants -- $11.60 -- $6.20 -- $5.80 -- $5.66 -- $5.46 -- $5.27
What I would like is if the order is 15 units, for style AFR701, for the query to bring up the $11.10 price. Or, if the order is 155000, to bring up the $5.25 price. Is this possible? Thank you.