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
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