Count/Sum Help

[derek-dc]

Hello,

Alright heres a problem for you's.

I have a table which holds roster information for staff. For each day in a 2 week period, there are 3 checkboxes, 'am' 'pm' and 'nt'. I need to perform a count on how many are 'am' 'pm' or 'nt'. For example, if 3 staff members worked on monday week 1 pm, i need it to return '3'. Problem is i am unsure how to perform a count on multiple fields?

Cheers

Derek

 

[Ziggy1]

It sounds like you don't have your table structured properly, the AM,PM & nt should be in one field, then you would easily be able to do a Count using a query.

 

[derek-dc]

Thanks Ziggy, though i have just used the =(sum(yes/no)*-1) formula in a report footer, which seems to be working fine for the moment

Cheers