I have a problem with an access 97 query
I have included the current query output.
for every 'SPEC' there are 6 possible values for 'INTMAN' ( 1 to 6).
I need to group by 'SPEC' where INTMAN = 1 then total the 'TOTAL'
column for that group.
example. new group total = 3
After this group the next grouping would display info for 'SPEC' = A1
and INTMAN = BETWEEN 2 AND 6 with the new group total = 19
and so on and so on with next group havin spec C11.
Cons Spec SpecDesc IntMan Status Total
BROWN A1 General Medicine 1 ADMIT 1
SHEPHERD A1 General Medicine 1 ADMIT 1
SHEPHERD A1 General Medicine 1 REMOVE 1
BROWN A1 General Medicine 2 ADMIT 1
SHEPHERD A1 General Medicine 2 ADMIT 1
SHEPHERD A1 General Medicine 2 ADMIT 2
SHEPHERD A1 General Medicine 2 ADMIT 3
SHEPHERD A1 General Medicine 2 PRECBH 1
SHEPHERD A1 General Medicine 2 REMOVE 1
SHEPHERD A1 General Medicine 2 WLACTV 1
BROWN A1 General Medicine 3 ADMIT 1
BROWN A1 General Medicine 4 ADMIT 1
CONNACHERA1 General Medicine 4 ADMIT 1
CURRIE A1 General Medicine 4 ADMIT 1
CURRIE A1 General Medicine 4 PRECBH 1
CURRIE A1 General Medicine 5 ADMIT 1
BOYD C11 General Surgery 1 ADMIT 1
BOYD C11 General Surgery 1 ADMIT 2
any advice / pointers that will let me total by spec where intman = 1
and also total by spec where intman is between 2 and 6 would be
greatly appreciated.
Thank you.