Query Date Parameter Write in Report

[ElTipo]

Hello People,

Is possible to write in reporte a query parameter? example

Between [Start date] and [End Date]

I need to put in report the Start date and End Date if the user put this date range in the popup parameter.

Is possible?

[NeoPa]

You would add a filter to the report when you open it :

...
  strWhere = "[DateField] Between #%F# And #%T#"
  strWhere = Replace(strWhere, "%F", Format(Me.FromDate, "m/d/yyyy"))
  strWhere = Replace(strWhere, "%T", Format(Me.ToDate, "m/d/yyyy"))
  Call DoCmd.OpenReport("ReportName", acViewNormal, ,strWhere)

[ElTipo]

Thanks Again Neo,

Is possible to write an SQL Code in the text box? If I create a textbox like

=Min[Start Date] to Max[End Date]

and this show the minimum and maximun for type user range.

Sorry for my english.

I try the code to view the result

[NeoPa]

I'm afraid I don't understand what you're asking, but my code basically does what I think you're after.

Me.FromDate & Me.ToDate refer to controls on your form (which can be TextBoxes).