Don't know how to build report

[Paul B.]

I need to build a report that gives percentages based on a query.

The query has 13 fields.

The first field is probably not needed, it is a record ID that matches in
all five tables being used.

The next 4 fields are Yes/No, one for each Unit#, Unit1 through Unit4

For each unit#, there are 2 corresponding fields, ie:

Unit1 'Yes/No'
Unit1Form2 'text'
Unit1CAMT 'text'

What I need to do is report on how many Unit#Form2 and Unit#CAMT fields are
blank where each Unit# is Yes.

In other words,

Unit1 = Yes, then if Unit1Form2 is blank, count it
Unit1 = Yes, then if Unit1CAMT is blank, count it

Unit2 = No, then don't count blank Unit2Form2 and Unit2CAMT

and so on through all 4 units.

Any assistance would be appreciated.

Cheers