Counting how many records have writing in two columns.

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

Guest

I am trying to finish a report that is to include a current calculation of:

# of total employees, # of hourly employees, # of salary employees, # of
employees on leave, # of current employees (not on leave), and finall (the
part I am having trouble with), # of salary employees on leave and current
salary employees as well as current hourly employees and hourly employees on
leave. I have four columns in my table and query I am linking from (hourly,
salary, LOA (means they on on leave), and schedule (means they are current).
For the first few calculations I just had it count the number of hourly
(anyone who has something written in the hourly column, et.c) I now want to
count how many people have writing or text in the salary column AND the leave
column. Or the hourly column AND the current column. What expression do I use
to count the data that meets both criteria?
 
To count the number of records in a report where both FieldA and FieldB are
not null:
=Sum(Abs( Len([FieldA] & "")>0 and Len([FieldA] & "")>0))
 
Back
Top