Making a text box call another one

[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

 

[Duane Hookom]

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])

 

[Jacques Latoison]

Thanks Duane,
It worked out well.

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
--

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