I am trying to write a query so that the user can select whatever date range they want. Only problem is the date file does not have a leading 0 so I am not sure how to get this to work?

Create a form with two unbound Text boxes named StartDate and EndDate. In the Criteria row of your query in the Date Column put this:

Between [Forms]![YourFormName]![StartDate] And [Forms]![YourFormName]![EndDate]

Then put a command button on the form to run your query or open a form based on the query. The user will enter the dates they are interested in in the two Text boxes and all should work.

[This message has been edited by Jack Cowley (edited 09-19-2001).]