Complicated Subtotals query

[grint]

Hi there - I've looked at quite a few posts and although some of them seem to start of heading in the right direction there doesn't appear to be anything that quite hits the spot for what I'm looking for.

I'm trying to create a query that creates the following (see spreadsheet as typing it out didn't help.)

I hope that's clear - any help appreciated.

Cheers,

Mark

 

[ThreeCrow]

Mark

What is your end goal with this, is it for an Entry Form or a Report or the out sde chance Both.

I've looked at your attachment and still (maybe its me) do not know what you want to do.