How to print preview by unique date on each page

[ukndoit]

I am trying to simplify my life. I need to take the data I have put into my data base, and print on a single day at a time. Almost always that will be todays date only. The date is stored in this format: mm/dd/yy or mm/dd/yyyy only. no time is stored.

How can I make a report only contain that information?
Thank you so much for any assistance you can be.

Richard

 

[dhookom]

Create a text box on a form with a default value of Date(). Then use the command button wizard to create a button to open your report. Then modify the code to read something like:

Dim stDocument as String
Dim strWhere as String
stDocument = "rptYourReportName"
strWhere = "1=1 "
If Not Isnull(Me.txtDate) Then
   strWhere = strWhere & " And [UnnamedDateField]=#" & _
        Me.txtDate & "# "
End If
DoCmd.OpenReport stDocument, 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]