In a querie i am trying to use a function where the user will have an option to enter two dates i.e from and to. And the results will show anything which lies bewteen the two dates.

Use the following criteria in your date field:

Between [Enter Start Date] And [Enter End Date]

HTH

[This message has been edited by Graham T (edited 11-29-2001).]