At section 4(02:23) you make a query that returns for each product the offers from vendors. My question is if there is a way to limit the offers not to the min cost, but to make a query that returns for each product the 3 lowest offers. I have for example five or more offers but I want to make a query that returns only the first minimum 3 offers for each product.
Reply from Alex Hedley:
There is an option in the ribbon for a TOP clause. It is a dropdown, probably says all at the moment. You have make this a percentage or a number. This is covered in Beginner Level 5 You can put in 3 here and have an Order By statement so the lowest are at the top
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.