Display Date Range on a MS Access Form

[cheli198201]

I'm totally new at this... please be patient with me.

I have Access 2007 and I'm working on form where I have multiple date fields associated with each record.

For example:
Name: Deadline1 Deadline2 Deadline3
John Doe 1/17/10 1/25/10 2/5/10

I want to be able to add a date range to the form so that the user can enter the start date and end date, on the actual form, and it will return only records that fall within that date range for any given deadline.

Is this easy to do?

Thank you!! This is driving me crazy.

[Stang02GT]

It can be complicated but you will need to construct a query to look at the values given in these two text boxes. I would suggest formatting these text boxes to make the users input the date in a certain format.

Once you have the dates i would make an "update" button (or something like this) to call your query. A quick google search will bring back numerous results and examples on queries where you want to bring back data in certain data ranges.