I have a table with 3 fields in it:
Order ID
Gift Name
Gift Quantity
an Order ID can be an order for several gifts, or just 1. So you might have a table like
Gb121 Gift Name 1 1
GB121 Gift Name 2 3
GB122 Gift Name 7 1
What I need is a logic statement that allows me the only display table items where the TOTAL number of gifts, per Order ID, is above x
Happy if that involves creating a beast mode extra field for example, I just don't know how to write the logic for the function.
Can anyone help?
Thanks
Stuart