Need help reworking a query

P

pokdbz

I have the 2 queries listed below that I need help with.

What I need to do is if MultiplecountID is >= 2 then I need to subtract one
in the QueryCountBaseRecords countCO_022 for every InterviewID in the
MultiplecountID query.
How do I change the QueryCountBaseReasons to do this?

QueryCountBaseReasons
countCO_022: DCount("[CO_022]","[Baseline Termination Form]","[CO_022]=1")

MultiplecountID
SELECT [Baseline Termination form].InterviewID,
([CO_022]+[CO_032]+[CO_042]+[CO_052]+[CO_062]+[CO_072]+[CO_082]+[CO_092]+[CO_102]+[CO_112]+[CO_122]) AS Multiple2
FROM [Baseline Termination form];
 
Top