Mantispony
Registered User.
- Local time
- Today, 17:56
- Joined
- Mar 31, 2011
- Messages
- 15
Hi, I thought I knew enough about Access until I took a look in here, lol.
(Feel free to move or delete this thread if appropriate)
My challenge is this:
I've got a list of customers and their sales values, as below:
custID | custName | custGroup | custValue
The custGroup field is where we keep track of who handles that customer regularly. I'd like an additional field CustTotalValue to display the sum of that person's group's sales.
Bottom line: When I filter on group 3, I'd like CustTotalValue to display the sum of custValue for group 3.
I'm not VBA fluent, so if this solution requires VBA; please pretend you're explaining it to a 3-year-old
Many thanks
(Feel free to move or delete this thread if appropriate)
My challenge is this:
I've got a list of customers and their sales values, as below:
custID | custName | custGroup | custValue
The custGroup field is where we keep track of who handles that customer regularly. I'd like an additional field CustTotalValue to display the sum of that person's group's sales.
Bottom line: When I filter on group 3, I'd like CustTotalValue to display the sum of custValue for group 3.
I'm not VBA fluent, so if this solution requires VBA; please pretend you're explaining it to a 3-year-old
Many thanks