Thanks Allen, That worked well when I put in the actual dates into the
criteria, but when I put in a parameter -ex: between [enter start date] and
[enter end date] it did not work. Is there a way to use a parameter this
way?

(I will work on redesigning my table as you suggested as well)
--
JoAnn


"Allen Browne" wrote:

In query design view, enter the date range in the Criteria row under the
first date field.

Below the Criteria row, you'll see another one marked Or. Enter the same
date range under the 2nd field, in the Or row.

Under the Or row is another Or row. Enter the same range on this next Or
row, under your 3rd date field.

If you often rehire people, it might be a better design to remove these
dates from your table, and put them in a related table (so someone can be
hired multiple times.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"JoAnn" wrote in message
...
In my database of employees I have three date/time fields - Agency Start
date, Rehire date (a lot of our employees only work part of the year) and
Separation Date. If I wanted to show only the employees who have either
started, were rehired or separated in a certain time frame, how would I do
that? Example: Which employees started or were rehired or separted
between
july 1 and july 30?
--
JoAnn

.