Report Totals Issue

[MikeHoward]

Hi All,



Kinda new to the database so any help would be greatly appreciated...

I have created a report/ Matrix to show a list of employees with dates of certain training. I need to some how add in some totals at the footer such as refresher totals if dates are less than today etc.

I have used a specific date (01/01/1900) to identify those that require training and conditional formatted the report so it looks lovely to the eye but i now need to count how many of them dates are in a column.

Is there a way I can put a few counts/ totals at the bottom of the report to then use to work out percentage complete etc

Thanks in advance to anyone brave enough

Mike

[pbaldy]

If I understand correctly you can count those with:

=Sum(IIf(FieldName = #1/1/1900#, 1, 0))