calculated sum reportfooter (1 Viewer)

[sven2]

Hello,

is it possible to calculate a field in the reportfooter?

The field is build like this:
Controle = Case Personeels_evaluaties2.eindevaluatie WHEN 'J' THEN 0 ELSE 1 END "

But when I try the fomula in the SQL:

Sum(Controle) I get an error that controle is not a column.

Thanks in advance,
Sven.

 

[Ron_dK]

Could this be of any help :

http://www.access-programmers.co.uk/forums/showthread.php?t=185071&highlight=calculated+field+report+footer