Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printing date ranges
- Thread starter Ryker7
- Start date
Stick a text box in the header and, in the control source (data tab), enter the value you want...
< M!ke >
Code:
="From " & Format(YourStartDate, "mm/dd/yyyy") & " To " & Format(YourEndDate, "mm/dd/yyyy")< M!ke >
For the following example, I am querying a table with three fields: "FName", "LName", and "Date".
The query's SQL syntax would be:
SELECT Table1.FName, Table1.LName, Table1.Date
FROM Table1
WHERE (((Table1.Date) Between [StartDate] And [EndDate]));
Then, I place a text box in the report header, and set the text box's Control Source property to:
="between " & [StartDate] & " and " & [EndDate]
That should do it!
The query's SQL syntax would be:
SELECT Table1.FName, Table1.LName, Table1.Date
FROM Table1
WHERE (((Table1.Date) Between [StartDate] And [EndDate]));
Then, I place a text box in the report header, and set the text box's Control Source property to:
="between " & [StartDate] & " and " & [EndDate]
That should do it!
- Status
Similar threads
