Calculated Field

  • Thread starter Thread starter stephent
  • Start date Start date
S

stephent

Hi,
I have a report which shows vehicle hire details, which are listed by
Employee_ID.
Under each Employee_ID is a list of each 'Trip' -T001, T002 etc.
I would like to put in a calculated field in the section header to show the
total number of 'Trips', i.e. the total for the T000 entries (not the total
of the numbers themselves, but the amount of Trips each employee has made)
Would someone please tell me the code, as a newbie I've been singularly
unsuccessful in finding it!!
TIA,
Steve.
 
I've found it now thanks...wrong use of () again. I'd tried Count, and
thought it wouldn't do the trick, but all is well now.
Thanks to all....who were going to help!!
Cheers,
Steve.
 
Back
Top