kaveman
Registered User.
- Local time
- Today, 02:12
- Joined
- May 12, 2004
- Messages
- 58
Hi Everybody,
I have a report that is driven by query similar to this:
SELECT DISTINCT (Select Sum([AMT]) FROM ACScust_sub3 WHERE TimeLeft >=365) AS AmtNotLastYear, ACScust_sub1.CAR
FROM ACScust_sub1, ACScust_sub3;
My problem is that certain select statements return no data. If they return no data I would want them to show up as 0 on my report but I can't get this to work.
Any suggestions?
I have a report that is driven by query similar to this:
SELECT DISTINCT (Select Sum([AMT]) FROM ACScust_sub3 WHERE TimeLeft >=365) AS AmtNotLastYear, ACScust_sub1.CAR
FROM ACScust_sub1, ACScust_sub3;
My problem is that certain select statements return no data. If they return no data I would want them to show up as 0 on my report but I can't get this to work.
Any suggestions?