between min/max dates title (1 Viewer)

[jedder18]

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.

 

[CJ_London]

you need to clarify what you are talking about. Fields or controls?

do you mean to use the dmin and dmax functions? min and max is a sql action used in a group by query

you get an error - what is the error description?

What is the Table? Do you mean record source rather than control source?

 

[jedder18]

I have a main report with no recordsource.
on this main report are 6 subreports all using a query with TBLNewMthlyClients as their recordsource.
I want to use this same table on the main report in an unbound control to give me the min and max intakedate that this report is being run for.

the error is in the field that the control is run just stating #error

 

[CJ_London]

sounds like you need to use dmin and dmax

="Between " & DMin("[IntakeDate]","TBLNewMthlyClients]") & " and " & DMax("[Intakedate]","TBLNewMthlyClients]")

 

[jedder18]

Perfect CJ London.
Thanks a million.