RE: Default dates in parameter values



I should have clarified that the person opening the report needs to option of
selection any start or end date but that most would be using the first day of
the year to the current day for a starting point thus the reason for the
default (user ease).

"Duchess" wrote:

I currently have parameters for reports for start/end dates with a defined
format:

SELECT *
FROM [Minor Injury]
WHERE ((([Minor Injury].Date)>=[Enter start date for report: 00/00/00] And
([Minor Injury].Date)<=[Enter end date for report: 00/00/00]) AND (([Minor
Injury].Dept)="AdTech Safety Team"))
ORDER BY [Minor Injury].Date;

I would like to have the start date default to the first day of the year and
the ending date to be the current date (now). How do I reword the SQL string
to get those values defaulted in?
.