Counting how many records have writing in two columns.

R

RCF217

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

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top