Show date parameter in report title even if no records are listed.

[louise]

Hello,
I have a report which lists new members since a given date. It is generated by a query that has the parameter: >= [Enter Date as m/d/yyyy].

Because I wanted the date to appear in the report title in a different format (and couldn't get it to reformat in the report), I have another field created in the query:


HeaderDate: Format([Enter Date as m/d/yyyy],"Long Date") which I refer to as a text box in the report title.

In addition to listing the new members, the report counts them and shows the total in a text box: =Count([MembInfo]![MembInfoID])

That all works ok unless there are no new members since that date. In that case, the header date is empty (presumably because there are no records in the list) and it looks like an error or failed report, rather than useful information.

Is there a way to show the Header Date even if there are no new members?

Thanks!

[June7]

I NEVER use dynamic parameters in queries. Popup inputs are especially bad because cannot validate user input.

Instead, have user input parameter to an UNBOUND textbox/combobox/listbox on form. The control can be referenced as dynamic parameter in query but I prefer to pass the criteria to report with OpenReport method.

DoCmd.OpenReport "report name", , , "[date field]=#" & Me.controlname & "#"

The textbox on report can refer to the control on form.

[ranman256]

I personally, have users enter the date in a form. They pick their report, and date from a date text box. THIS drives the query criteria, not an on the fly param.
select * from tbl where [date]=forms!frmRpts!txtDate

but for your header date you can put an unbound text box and use the same date box in the form...forms!frmRpts!txtDate

[louise]

Thank you both! Very helpful.