Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report requiring the count for two fields into one 1

Status
Not open for further replies.

dlbriere

Instructor
Oct 27, 2002
3
US
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
 
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
 
Paul

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

Don
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top