***Resolved***sql syntax help pls

[beasty1711]

I'm trying to do some SQL to extract some data
I need to filter the data like so:

B>= A & C>=A
OR
B>=A & C<=D
OR
B<=D & C>=D

Soo far I have...

SELECT MAX(Cost) AS 'MAX', MIN(Cost) AS 'MIN', SUM(NumSites) AS sites, COUNT(ID) AS 'COUNT'
FROM tCampaignData
WHERE (ContractorCode = 6) AND (Packagecode = 19) AND (SizeCode = 2) AND (Cost <> 0) AND campcode <> 155
   AND (ID IN
        (SELECT id FROM tcampaigndata WHERE startdate <= '2002-Dec-23' AND enddate >= '2002-Dec-23')) 
   or(ID IN
        (SELECT id FROM tcampaigndata WHERE startdate >= '2002-Dec-23' AND enddate <= '2003-Mar-30')) 
   or(ID IN
        (SELECT id FROM tcampaigndata WHERE startdate <= '2003-Mar-30' AND enddate >= '2003-Mar-30'))

Any ideas where i am going wrong and/ or if its possible to do what i need??

[brucevde]

What database? Why the subqueries? Just add the criterias to your where clause. If this is an Access database then date fields must be surrounded with # not '.

SELECT MAX(Cost) AS 'MAX', MIN(Cost) AS 'MIN', SUM(NumSites) AS sites, COUNT(ID) AS 'COUNT'
FROM tCampaignData
WHERE (ContractorCode = 6) AND (Packagecode = 19) AND (SizeCode = 2) AND (Cost <> 0) AND campcode <> 155
 AND (  (startdate <= '2002-Dec-23' AND enddate >= '2002-Dec-23') OR 
        (startdate >= '2002-Dec-23' AND enddate <= '2003-Mar-30') OR 
        (startdate <= '2003-Mar-30' AND enddate >= '2003-Mar-30')
     )