use current date to find records that are in a period between 2 da

[Guest]

How do I set up my table or write formulas for the following:

I want to type in two dates in my table, either as two columns (StartDate
1/01/05 and FinishDate 1/06/05) or as one column (DatesFrom 1/01/05 - 1/06/05)

Then I need to set up a search if I enter in the current date or a
particular month (march) or (1/03/05) and on entering that, I want the
records to come up that have that date between its time period: (StartDate
1/01/05 and FinishDate 1/06/05) or as one column (DatesFrom 1/01/05 - 1/06/05)

If anyone can please help me with this or give me a web site page that has a
"how to" process, this will be very helpful and all is appreciated.

Contact me at: (e-mail address removed) with any info please!!!!!!!!!!!!

 

[Damiaan]

Make a table with 2 different fields. StartDate and FinishDate.

Then make a query where you put in the criteria (on the same line)
Startdate >= #1/3/05#
and
EndDate <= dateadd("m",#1/3/05#)

 

[Guest]

Damiaan, thankyou so much for your help. Your formula didnt work, however
after playing around with it, this is what Ive managed to do letting me put
in this formula without my office assistant telling me there is an error:

In OBJECTS, QUERIES, I opened up my table: Table1 Query. Then put it in
DESIGN VIEW. In the CRITERIA row under my "Date Start" and "Date Finish"
column, I put in this formula:

Startdate >= #1/3/05#

EndDate <= #1/6/05#

This resulted in letting me close that box down, opening up "Table1 Query"
again, but nothing was there. The title said "Table1 Query: Select Query"
and if I typed anything the Primary Key would go to a new number.

What did I do wrong? Where can I go from here? What else can I try?
Any help is very much appreciated
-Kit