Re: Access 2000 date range using today's date

"Active" means the current date is between the start date and the end
date.
OR
Start Date is in the past. End Date is not.

SELECT tblContracts.ContractID, tblContracts.StartDate,
tblContracts.EndDate
FROM tblContracts
WHERE (((tblContracts.StartDate)<=Date()) AND
((tblContracts.EndDate)>=Date()));


If you wanted to make it more flexible, you could point the criteria at
an unbound form and then set up two textboxes formatted as dates. then
find anything inside the range.

.

Relevant Pages

  • RE: Using Unbound Form to Enter Query Criteria
    ... I am trying to use an unbound form to specify the criteria ... In the unbound form, I have multiple fields, where any of them ... > may be filled in to further filter the results. ... To enter the criteria for the query, I set the criteria field to look ...
    (microsoft.public.access.queries)
  • RE: Unbound Form for Criteria
    ... It will take more than an unbound form for the criteria to get your data. ... You will have to add a calculated field to apply the criteria to. ... Current Qtr vs. ...
    (microsoft.public.access.forms)
  • Re: Reuse dialog box?
    ... what you need to do is develop an unbound form and fill its ... boxes to help filter data. ... the forms underlying query contains this criteria ... dialog boxes and multiple display forms? ...
    (microsoft.public.access.forms)
  • Using Unbound Form to Enter Query Criteria
    ... I am trying to use an unbound form to specify the criteria ... may be filled in to further filter the results. ... To enter the criteria for the query, I set the criteria field to look ...
    (microsoft.public.access.queries)
  • Re: Countif/And Function
    ... >> criteria. ... >> this be done using the COUNTIF or AND functions?? ... >> count the number of cells in column E with a value of N in column E AND a ... Prev by Date: ...
    (microsoft.public.excel.misc)