Making a text box call another one

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

I have a report that shows a list of workers in one column, and hrs worked
in the second column.

At the bottom of the report (in the report footer) is a sum of all the hrs
worked.
Under that I need to list a specific position all the time so I can see what
the total hrs worked would be minus that particular position.

The position in question is a record, so how do I list that one (its the
corresponding hrs that count, not just the lable) or rather how do I tell a
text box to always call on a specific record?

Thanks beforehand
 
I expect you can describe the "record" selected with an expression like
"[Position]='Supervisor' " or something similar. To get the hours for this
record you can use an expression like:
= Sum(Abs(Position]="Supervisor") * [HrsWorked])
 
Thanks Duane,
It worked out well.


Duane Hookom said:
I expect you can describe the "record" selected with an expression like
"[Position]='Supervisor' " or something similar. To get the hours for this
record you can use an expression like:
= Sum(Abs(Position]="Supervisor") * [HrsWorked])

--
Duane Hookom
MS Access MVP
--

Jacques Latoison said:
I have a report that shows a list of workers in one column, and hrs worked
in the second column.

At the bottom of the report (in the report footer) is a sum of all the
hrs worked.
Under that I need to list a specific position all the time so I can see
what the total hrs worked would be minus that particular position.

The position in question is a record, so how do I list that one (its the
corresponding hrs that count, not just the lable) or rather how do I tell
a text box to always call on a specific record?

Thanks beforehand
Click to expand...
Click to expand...
 
Back
Top