Report Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which tracks inspections on incoming materials. My report
shows all of the rejections for a period of time. The user enters a start
date and a finish date in the query. I am wondering how I would show the
value that is inputted.

Donbenz
 
If the Report record source include a filter such as
Select * From TableName Where DateField Between [Please Select Start Date]
And [Please Select End Date]

Then you can create a Text Box in the rpeort, and in the control source write
= "Between " & [Please Select Start Date] & " And " & [Please Select End Date]
 
Would I select the * in the query mode. I am unfimiliar with using filters.

Ofer Cohen said:
If the Report record source include a filter such as
Select * From TableName Where DateField Between [Please Select Start Date]
And [Please Select End Date]

Then you can create a Text Box in the rpeort, and in the control source write
= "Between " & [Please Select Start Date] & " And " & [Please Select End Date]

--
Good Luck
BS"D


Donbenz said:
I have a report which tracks inspections on incoming materials. My report
shows all of the rejections for a period of time. The user enters a start
date and a finish date in the query. I am wondering how I would show the
value that is inputted.

Donbenz
 
Back
Top