Trying to place a title on a report with many subreports all using the same table.
Included in this table is a date field.
="Between " & Min([TBLNewMthlyClients].[IntakeDate]) & " and " & Max([TBLNewMthlyClients].[Intakedate])
get a #error on report run.
Obviously, control not correct.
What's not obvious is why? to me anywho!
I should mention, the overall report does not have a control source of this table.
All the subrpts that are on the main report are using the Table as the control source.
Included in this table is a date field.
="Between " & Min([TBLNewMthlyClients].[IntakeDate]) & " and " & Max([TBLNewMthlyClients].[Intakedate])
get a #error on report run.
Obviously, control not correct.
What's not obvious is why? to me anywho!
I should mention, the overall report does not have a control source of this table.
All the subrpts that are on the main report are using the Table as the control source.