Report-Printing Selected Dates whether another value is found or n

[Guest]

I use Access 2003.
I use a query to select a value between two dates. The auditors want to see
the report including the dates on the report or page header even if the value
is not found.

The query statements are

Between [ENTER START DATE] And [ENTER END DATE] for the "OPEN DATE" field
and
Like "*" & "NETVIEW" & "*" for the INITIAL DESCRIPTION field.

ANY help is appreciated

 

[Guest]

Are you entering these dates through a form? Ideally you would, and then you
can simply include text boxes, in your report header, referencing the fields
on the form.

You can possibly use an IIF statement, for the report output, to display a
text value (ie. "No Records Found"), rather than printing a blank report.

HTH

Sharkbyte