I want to create a query that will only return the results if the main date
(date1) does not either equal date2 and date3.

Any suggestions on how to do this?
--
May MacKenzie
Administrative Assistant

In SQL

Select * From TableName
Where Date1 <> Date2 And Date1 <> Date3

Or, in the query in the criteria section, write Under Date2 and Date3

<> Date1

--
Good Luck
BS"D


"MaggieMay" wrote:

> I want to create a query that will only return the results if the main date
> (date1) does not either equal date2 and date3.
>
> Any suggestions on how to do this?
> --
> May MacKenzie
> Administrative Assistant