I have a report which displays the status of applicants, the applicants are grouped by Area of interest and then by status. There is a total for the amount of applicants in each area of interest, this is acquired by having a field in the footer of the Status grouping with the following code:
="Count of " & [Status] & " in " & [Area_Of_Interest] & " = " & Count([Reference])
The above counts the Reference Number which has been assigned to the applicant.
What I want is to also have a summary at the bottom of the report of the number of each applicant of each different Status.
The report would look like:
Status Number
Approved 4
Declined 3
Commenced 1
I have been told to use a subreport using a query which I have tried but I don't know what way to have the query.
Any suggestions...
="Count of " & [Status] & " in " & [Area_Of_Interest] & " = " & Count([Reference])
The above counts the Reference Number which has been assigned to the applicant.
What I want is to also have a summary at the bottom of the report of the number of each applicant of each different Status.
The report would look like:
Status Number
Approved 4
Declined 3
Commenced 1
I have been told to use a subreport using a query which I have tried but I don't know what way to have the query.
Any suggestions...
