Thread: Trying to get sum help

Hey w0lffy,

Ok, yes I think I would a join but I'm still not sure how this would work if I'm checking both fields for each district. I'll just enter each one into the sql syntax for now and come back to this.

Code:

WHERE (((qryTonyFirstTestRun2.Districtcode) Like "*OK*")) And (((qryTonyFirstTestRun2.Func_Loc_CD) Like "*OK*")) or 
(((qryTonyFirstTestRun2.Districtcode) Like "*HD*")) And (((qryTonyFirstTestRun2.Func_Loc_CD) Like "*HD*")) or
(((qryTonyFirstTestRun2.Districtcode) Like "*AK*")) And (((qryTonyFirstTestRun2.Func_Loc_CD) Like "*AK*"))

I think I would need something to look at District code value(s) then look at the func_loc_cd to see if it matches the district code...

Code:

WHERE (((qryTonyFirstTestRun2.Districtcode) Like "*@@VALUE*")) And (((qryTonyFirstTestRun2.Func_Loc_CD) Like "*@@VALUE*"))

Thanks so much w0lffy for getting me straight to get the results I needed... It was my first union query in access.