Report based on parameter query

[krankyboy]

Hi,

I have a query that I want to run a report off of. I've defined two parameters of date/time type, [stDate] and [enDate]. These two parameters are then used in 6 columns of the query.

Can I just use the Where clause in the Docmd object such as
[stDate] = some value in my textbox,
[enDate] = " " to populate the parameters correctly?

Thanks,

A

 

[THWatson]

krankyboy
Try something such as
DoCmd.OpenReport YourReportName, acPreview, , "[stDate] = '" & Me.YourTextBox & "'"

Tom

 

[dhookom]

Six different date columns sounds a bit un-normalized. My approach would be similar to Tom. I try to remove ALL dynamic criteria from report record sources. Build them into a where clause as Tom suggests. Dates need to be delimited with "#" so your where clause might be:

Dim strWhere as String
strWhere = "[DateFieldA] Between #" & Me.txtStDate & "# AND #" & _
    Me.txtEnDate & "# "
DoCmd.OpenReport YourReportName, acPreview, , strWhere

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]