Report requiring the count for two fields into one 1

[dlbriere]

I maintain a vocational education data base requiring a report on the vocational completion rates. Currently the relevant fields used are:
Voc1 = AS,AB,BT,RS,EW,PL,FM, or HO
Voc2 = Same as above
V1 Status = C or NULL
V2 Status = C or NULL
St Status = T or NULL (T = terminated)

I am currently using a DCount statement to count the number of completers in particular vocation. Many students complete two vocs, so I need to be able to add togther the completers who complete say Voc1 = AB with those who complete Voc2 = AB.

Is there an easy way to accomplish this.

Thanks for the Help.
Don

 

[PaulBricker]

Don, it depends on how your info is set up, but try this in the Report Footer. It may do it for you.

=Sum(IIf(Voc1 = "AB" And V1Status = "C" Or Voc2 = "AB" And V2Status = "C", 1,0)

Paul

 

[dlbriere]

Paul

Thanks for the help - that did it for me. It was easier than I expected.

Don