pulling dates into a report.....

[JennW]

I have several tables in my database. Lets call them tables red, white and blue.

Based on information from table red a report is generated.
The red table was created from a make-table query. Part of this make-table query was a criteria of a date range.

What I am trying to do is have the criteria that is entered in this query appear in a text box in the report footer. This way when you read the report you will know what date range encompasses this data.

Is there a way to do this?

thanks so much!

JennW

 

[mdthornton]

The easiest way would be to include the date range in your make table query and just add those columns to your report footer. Good Luck,
Mike T

 

[Aivars]

Put your needed date in VBA codes (event ReportFooter: OnFormat):

e.g.

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
me.txtDate=dlookUp("MyDate","MyQuery",MyCriteria)
end sub

Aivars