Counting field values within a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using windows XP and Access XP. I am creating a report of employed
clients . I am trying to determine how many clients are avialable for
employment. I was icly using a =count([lastname])formula to determine
eligibility. That was a mistake on my part becuase the next time the report
is generated the names appear again but this time they appear as employed
individuals . The last name field still gets counted and yet they are no
longer available for employment . My problem is that in the report text box,
I need a formula that counts lastname only if the field named [employment
code ="se" which stands for seeking employment] .

THis would be a countif formula if I were in excel Does Access have an
equivalent?
I know how to do the Count([employment code])formula. How do I do it in
this case where they are only counted if their employment code is "se"? I
can't pull from the original table because the form is based on a query that
only deals with people who graduated in 2005 and not before. I need a Dcount
which has multiple criteria ( i.e. that the graduation date >="1/1/2005" and
the employment code = "se". Can this be done?

Thanks in advance

Tom



Thanks so much for your help
 
I am using windows XP and Access XP. I am creating a report of employed
clients . I am trying to determine how many clients are avialable for
employment. I was icly using a =count([lastname])formula to determine
eligibility. That was a mistake on my part becuase the next time the report
is generated the names appear again but this time they appear as employed
individuals . The last name field still gets counted and yet they are no
longer available for employment . My problem is that in the report text box,
I need a formula that counts lastname only if the field named [employment
code ="se" which stands for seeking employment] .

THis would be a countif formula if I were in excel Does Access have an
equivalent?
I know how to do the Count([employment code])formula. How do I do it in
this case where they are only counted if their employment code is "se"? I
can't pull from the original table because the form is based on a query that
only deals with people who graduated in 2005 and not before. I need a Dcount
which has multiple criteria ( i.e. that the graduation date >="1/1/2005" and
the employment code = "se". Can this be done?

Thanks in advance

Tom



Thanks so much for your help
Click to expand...

GraduationDate is Date datatype and Employment Code is Text datatype.
Correct?

=Sum(IIf([employment code] = "se" and [Graduation Date] >=
#1/1/2005#,1,0))
 
Back
Top