count various negative results

[dgb]

Can anyone help?
I have a query of all records. Each record has 10 fields that can contain a normal value or a negative result. I would like to count the negative records and then perform a calculation to show the percentage of times the result was negative. I need to do this calculation for each of the fields.
For example in the same table i want to calculate how many times a patient did not meet criteria, and how many times the form was not filled out correctly.
Thanks in advance. Dan

 

[BLeslie88]

Do you wish to do so on a report..?

If this is the case it's easier....
You need 2 record counter...
txtBoxes on a report counting records with this code.

txtBoxes Running sum Over Group or Over All

Recordcount
=IIf([txtField]>=0,1,0)
Recordcount2
=IIf([txtField]<0,1,0)

txtPercent in group footer or report footer
=[RecordCount2] / ([RecordCount] + [RecordCount2])

Regards,