R
RBDU
Hi All! Thanking anyone for a reply. Access97
I have a job sheet form where you can add up to six operator names in the
six fields available.
Another field [total operators] you input the total number of operators that
attended a job. Instead of inputting the number of operators that attended I
tried putting =count([operator 1] + [operator 2]) in the field [total
operators], but this adds up all the operator names in the entire database.
I only want to do it for that particular job. That is if I have 2 operators
that attended a job, [total operators] will equal 2, not 2691 for the whole
database.
Regards
Peter
I have a job sheet form where you can add up to six operator names in the
six fields available.
Another field [total operators] you input the total number of operators that
attended a job. Instead of inputting the number of operators that attended I
tried putting =count([operator 1] + [operator 2]) in the field [total
operators], but this adds up all the operator names in the entire database.
I only want to do it for that particular job. That is if I have 2 operators
that attended a job, [total operators] will equal 2, not 2691 for the whole
database.
Regards
Peter