validation rule with msgbox using macros

[moonlight via AccessMonster.com]

Steve,

Thanks it works fine,I have a report show all employers born on 1982 , but I
want to count how many employer was born in that year in the report. for
example the report I want it look like this
Department name Employername #
Department 1 Employer1 #1
Department 2 Employer2 #2
Department 2 Employer3 #3

I know I should do it in query in the first place , but now to late I
rearrange the report and I can not start over again if there is away to do it
in the report?


My Regards,

 

[Steve Schapel]

Moonlight,

I'm not sure if this is what you mean... But if you put an unbound
textbox in the Footer section of the report, with its Control Source
entered like this:
=Count(*)
.... maybe this is what you want?

 

[moonlight via AccessMonster.com]

Steve

if I want to count all employers, I mean a way to give the first one(employer)
number 1 and the second number 2 and so on in the report.


My Regards,

 

[Steve Schapel]

Moonlight,

Put an unbound textbox in the Detail section of the report. Set its
Control Source like this:
=1
.... and then set its Running Sum property to 'Over All'