RE: Default dates in parameter values
- From: Duchess <Duchess@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Aug 2008 09:45:02 -0700
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?
- References:
- Default dates in parameter values
- From: Duchess
- Default dates in parameter values
- Prev by Date: RE: records with current year
- Next by Date: Re: Help! Outer Join problem
- Previous by thread: Default dates in parameter values
- Next by thread: Re: Default dates in parameter values
- Index(es):