newbie's question

[hcj]

Hi Raj,
In the criteria of date field in the query enter:

=[Enter earliest date desired] and <=[Enter latest date

desired]

The text in the square brackets above will prompt the
user for the start and end dates desired and limit the
record set to dates in that range.

Hope this helps

-----Original Message-----
I am using access 97.

I have a table with 5 fields(1 date fields). I want to

create a query/report dynamically depending upon the users
requirement.

1) i want to know how i can get input from the user
2) how to generate the query out of it

i.e. if the user keys in 10/12/2003 and 15/12/2003, than

i want to list only those records who's date field is in
between these range.