I'm doing a stock control system, and wish to use a parameter query to search records. I want my End User to be able to enter the dates between which to search, but don't know how to. Can anyone help me please.
Rob

Hi Rob,

In Design View for your query, find the date field you wish to have the search center on and in the Criteria box type:

Between ([Begin Date]) AND ([End Date])

When run, the user will be asked to enter a beginning date and ending date.

Hope this helps. :-)

Bluez

[This message has been edited by Bluezman (edited 01-11-2002).]

Or you could use this:
>=[Enter Start Date]And<=[Enter End Date]