Hello,
I have been fighting with this Access query all morning, however, I think I am close. Right now, it is not complete, but you will get the idea. What I am trying to do is if sales (IVRNET3) are between certain numbers than categorize them in the AUV Strat field. I am using switch , however, this query gives me a Syntaxt error (missing operator error). Please help.
SELECT Switch([ 2999.99 <= Factsalesweekly.[ivrnet3] > 0,'000-2999') As 'AUV_STRAT',F.DateOfBusiness,
f.Storenumber ,IVRNet2, IvrNet3
FROM vwSiteType st INNER JOIN vwStoreAdHoc sa
ON St.SiteType = SA.SiteTypeName
INNER JOIN FactSalesWeekly f
ON SA.StoreNumber = F.StoreNumber
WHERE (((F.DateOfBusiness)>='6/24/2012' And
(F.DateOfBusiness)<='07/8/2012') AND
((St.SiteTypeCategory)='Trad (x C&G)') AND
((F.WeeksOpenAsOf)>26) AND
((SA.Country)='USA') AND
((sa.CloseDate) Is Null Or (sa.CloseDate)>=([DateOfBusiness]-6)) AND
((sa.StateOrProvince)<>'PR') AND
((F.QuarantineFlag)=0))
I have been fighting with this Access query all morning, however, I think I am close. Right now, it is not complete, but you will get the idea. What I am trying to do is if sales (IVRNET3) are between certain numbers than categorize them in the AUV Strat field. I am using switch , however, this query gives me a Syntaxt error (missing operator error). Please help.
SELECT Switch([ 2999.99 <= Factsalesweekly.[ivrnet3] > 0,'000-2999') As 'AUV_STRAT',F.DateOfBusiness,
f.Storenumber ,IVRNet2, IvrNet3
FROM vwSiteType st INNER JOIN vwStoreAdHoc sa
ON St.SiteType = SA.SiteTypeName
INNER JOIN FactSalesWeekly f
ON SA.StoreNumber = F.StoreNumber
WHERE (((F.DateOfBusiness)>='6/24/2012' And
(F.DateOfBusiness)<='07/8/2012') AND
((St.SiteTypeCategory)='Trad (x C&G)') AND
((F.WeeksOpenAsOf)>26) AND
((SA.Country)='USA') AND
((sa.CloseDate) Is Null Or (sa.CloseDate)>=([DateOfBusiness]-6)) AND
((sa.StateOrProvince)<>'PR') AND
((F.QuarantineFlag)=0))