Could create the date parameter and then in the Record Selection do a formula something like:
({Jail_Confinement.Date_Confined}<={dateparam}
and
{Jail_Confinement.Date_Released}='')
or
({Jail_Confinement.Date_Confined}<={dateparam}
and
{Jail_Confinement.Date_Released}>{dateparam})
I believe that should work. If not, it may give you an idea of what you could do.
Also, for the {Jail_Confinement.Date_Released}='' you may have to do isnull({Jail_Confinement.Date_Released})
Edited by FrnhtGLI - 15 Feb 2010 at 10:32am
IP Logged
