Report Dates

D

Donbenz

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
 
O

Ofer Cohen

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]
 
D

Donbenz

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
Click to expand...
Click to expand...
 
Top