By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,658 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,658 IT Pros & Developers. It's quick & easy.

How to query results if a price is greater than a sell price?

anoble1
100+
P: 225
I have ran into a pickle. I have data where I only want to show results where the actual sell price is greater or equal to a list price in the system. In other words I want to show only instances where you sold it for more than the system has in this List field.

How do I do that?
I have 2 columns of Data. List Price and Sell Price. Do I somehow use some criteria or combine a formula in the "Field"?
Would like to say something like
Expand|Select|Wrap|Line Numbers
  1. IF SELL >= List Price then Show the data else do not show data if you sold under List
Help?
Jun 13 '17 #1

✓ answered by NeoPa

The simple answer is to include criteria (WHERE clause) along the lines of :
Expand|Select|Wrap|Line Numbers
  1. WHERE ([SellPrice]>=[ListPrice])

Share this Question
Share on Google+
2 Replies


anoble1
100+
P: 225
How about that. Tied something new for me.
Expand|Select|Wrap|Line Numbers
  1. >=[QS36F_PARTMAST]![PM_LIST]
Worked

I put this in the Criteria section of the query in Access.
Jun 13 '17 #2

NeoPa
Expert Mod 15k+
P: 31,487
The simple answer is to include criteria (WHERE clause) along the lines of :
Expand|Select|Wrap|Line Numbers
  1. WHERE ([SellPrice]>=[ListPrice])
Jun 13 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.