Query by date excluding particular months

[Shilohcity]

Hi there

I have a range of data I am trying to query based upon all sorts of things but one particular part is that it must not have date between 23 April 2001 and 5 July 2001.

I have everything working except the date part and Im, not really sure where to start with this. I guess I need to group by date and then use a not like the date range but it doesnt seem to work.

Anyway my query so far:

SELECT dbo_Customer.EMail_Addr, dbo_Customer_Sector.Flight_Date
FROM dbo_Customer INNER JOIN dbo_Customer_Sector ON dbo_Customer.Customer_No = dbo_Customer_Sector.Customer_No
GROUP BY dbo_Customer.EMail_Addr, dbo_Customer_Sector.Flight_Date, dbo_Customer.Country, dbo_Customer.EMail_Subscriber
HAVING (((dbo_Customer.EMail_Addr)<>&quot;&quot AND ((dbo_Customer.Country) Like &quot;n*&quot AND ((dbo_Customer.EMail_Subscriber)=&quot;Y&quot);


All help is most appreciated.

Justin.X-)
&quot;Creativity is the ability to introduce order into the randomness of nature.&quot; Eric Hoffer

Visit me at

http://www.dfodesign.co.nz

 

[Qaroven]

well for the example above why not add something like

WHERE dbo_Customer_Sector.Flight_Date > '5-Jul-2001' or
dbo_Customer_Sector.Flight_Date < '23-Apr-2001' Ben
+61 403 395 052