count critical

[prabhus]

Hello all,

I have the huge bunch of data (approximately 4000 lines of data) as shown in the attached excel file. From this table, i want to make a report something like, on everyday the count of "YES" and count of " NO " using query. Please suggest me how to do this using query.
Thanks for your support.

 

[Galaxiom]

Import to Access then derive a field to convert the Yes and No to Boolean.

Yes/True is stored as -1 while No/False is stored as 0. Sum the values in the fields and reverse the sign to get the count of True in the field.

This Sum is easier done in a form/report than a query because a set of subqueries would be required to separately sum each field. Add textboxes to the footer and enter the following as the ControlSource:

=Sum([fieldname])

BTW. 4000 is a small dataset for Access.