P
pilch74
Please help I'm absolutely stuck on this one, and I need assistance
pretty badly. I'm issuing a query whereby my order source field has 3
possible values, either c w or blank. But in this case blank isn't
null it's just the 3rd option, phones.
c = cog
w = web
blank = phone.
This is my query so far.
SELECT tblOrderTrans.clubno, Count(tblOrderTrans.orditem) AS [number
of orders], Nz([tblOrderTrans.ordsrc],"P") AS [order type],
Sum(tblOrderTrans.ordvalue) AS SumOfordvalue
FROM tblOrderTrans
WHERE (((tblOrderTrans.ordpremprodflag)<>"P") AND
((Year([orddate]))=2007))
GROUP BY tblOrderTrans.clubno, Nz([tblOrderTrans.ordsrc],"P")
HAVING (((Count(tblOrderTrans.orditem))<>8113));
I've looked at creating a new lookup table just to provide full names
for these order sources but when I link the tables and run the report
the Nulls just don't show up - sure there's an exaplanation for that
too..
Look forward to hearing from you (or anyone).
Regards,
Rich.
pretty badly. I'm issuing a query whereby my order source field has 3
possible values, either c w or blank. But in this case blank isn't
null it's just the 3rd option, phones.
c = cog
w = web
blank = phone.
This is my query so far.
SELECT tblOrderTrans.clubno, Count(tblOrderTrans.orditem) AS [number
of orders], Nz([tblOrderTrans.ordsrc],"P") AS [order type],
Sum(tblOrderTrans.ordvalue) AS SumOfordvalue
FROM tblOrderTrans
WHERE (((tblOrderTrans.ordpremprodflag)<>"P") AND
((Year([orddate]))=2007))
GROUP BY tblOrderTrans.clubno, Nz([tblOrderTrans.ordsrc],"P")
HAVING (((Count(tblOrderTrans.orditem))<>8113));
I've looked at creating a new lookup table just to provide full names
for these order sources but when I link the tables and run the report
the Nulls just don't show up - sure there's an exaplanation for that
too..
Look forward to hearing from you (or anyone).
Regards,
Rich.