Count

[tikkat3]

This should be a simple problem to solve, but not for me!

I am trying to get a simple 2 field result in the Report Footer. The 2 fields are "ProjE" and "Total Open Projects". All that I want is a list of the 5 Project Engineers and a count of the number of projects associated with their name that are still current.

In the main Detail of the report I have a list of all current projects with the fields: "ProjE"; "C/QNumber"; "EndUser"; "SiteName".

I have tried placing "=Count([C/QNumber])" in the "Total Open Projects" Control souce box. It just counts the total open projects. At the same time the ProjE list remains empty.

I am sure that I am doing something very basic wrongly. Please help.

 

[Dennisk]

you mention 2 fields however you also mention 5 project engineers. You cannot get the name of 5 engineers into one field ( well you can but you need to be able to write a VBA function that would retreive and then concatenate the engineers names and use that as its return value). a list is a list is a list.
consider a sub report instead.

 

[tikkat3]

5 project engineers is correct. Their names are all records within the ProjE field I have probably explained it badly.

In the main detail section of the report each and every job is listed with the project engineer's name, job number, client name, client site. This is laid out in a tabular format with each job being shown in a row, one below the other.

I am possibly not thinking logically, but am wanting the same tabular style in the report footer with the list of the project engineer names and to the right of them in a separate field, the total count of jobs associated with their names.