G
Gwen H
I have a report that lists loan officers and their loan sales for the
previous month. Some loan officers supervise others, and therefore the report
is grouped on the Supervisor field.
In the detail section, how do I hide an entire record if the loan officer's
name is the same as the supervisor's name? Here is the code I tried to use in
the detail section, but it only hides the field containing the loan
officer's name; I need to hide the entire record. BUT, I still need the data
to be in the report so that the loan sales numbers can be used on
calculations on the report.
If Loan_Officer = Supervisor Then
Me.Loan_Officer.Visible = False
Else
Me.Loan_Officer.Visible = True
End If
Any help would be greatly appreciated!
GwenH
previous month. Some loan officers supervise others, and therefore the report
is grouped on the Supervisor field.
In the detail section, how do I hide an entire record if the loan officer's
name is the same as the supervisor's name? Here is the code I tried to use in
the detail section, but it only hides the field containing the loan
officer's name; I need to hide the entire record. BUT, I still need the data
to be in the report so that the loan sales numbers can be used on
calculations on the report.
If Loan_Officer = Supervisor Then
Me.Loan_Officer.Visible = False
Else
Me.Loan_Officer.Visible = True
End If
Any help would be greatly appreciated!
GwenH