validation rule with msgbox using macros

  • Thread starter Thread starter moonlight
  • Start date Start date
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,
 
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?
 
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,
 
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'
 
Back
Top