Access 2000 date range using today's date

[Cy]

I have a custom access 2000 database, that has contracts with starting
and ending dates. What I'd like to be able to do, is key in a date, say

today 9/2/05 and get a list of all "current" contracts. So, for example

contract A started 1/1/05 thru 12/01/05, contract B is from 9/4/05 thru

9/4/06 and contract C is from 8/4/04 thru 8/4/06. If I input 9/2/05 as
today's date, I want the result to show me that Contract A and Contract

C are the current contracts in force today.
Any ideas/direction you can offer?
I hope I provided enough information.
Thanks in advance.

[pietlinden]

"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.

[Cy]

Thanks.. I cannot believe it was that simple and I didn't think of it
that way. Always good to see that folks are willing to lend a hand,
even if this problem was a simple one. Duh on my part...:)

Much appreciated.