Hi!
I have a table with the following fields:
Group_ID
Offer_ID
Notes
Total _ sum
Selection
I would like to build a query that would show only those records (Offer_ID) for each Group_ID that are not selected and for which the sum is less than the sum of the selected Offer_ID.
Please advise how can I do that.
I'm using access 2010 and don't have a lot of experience with using it.
I have a table with the following fields:
Group_ID
Offer_ID
Notes
Total _ sum
Selection
I would like to build a query that would show only those records (Offer_ID) for each Group_ID that are not selected and for which the sum is less than the sum of the selected Offer_ID.
Please advise how can I do that.
I'm using access 2010 and don't have a lot of experience with using it.