microsoft/access/training/courses - Subtotals

hi Andrea

I have emailed you a possible solution to your gmail account.

Basically you can do it by using match & index, similar to Vlookup. The different is that Vlookup only works one way, whereas the index and match can be assembled to your requirements.

Take a look at the attachment and see if you can see how I did it. IF so, apply it to your situation.


Richard