Mike Hughes
Registered User.
- Local time
- Today, 22:11
- Joined
- Mar 23, 2002
- Messages
- 493
Why is there no FINAL AMT for cases that have nothing in the AMT2 column?
Would someone please show me how to change this query to correct this issue?
SELECT
[22 TBL].CASE,
[22 TBL].AMT1,
[22 TBL].AMT2,
Sum([22 TBL].AMT1+[22 TBL].AMT2) AS [FINAL AMT] INTO [23 TBL]
FROM [22 TBL]
GROUP BY [22 TBL].CASE, [22 TBL].AMT1, [22 TBL].AMT2;
CASE____________AMT1_____________AMT2___________FINAL AMT
00652490P_______$1,622.25________$1,622.25________$3,244.50
00735400P_______$1,560.00_______________________________
00981230P_______$1,900.00_______________________________
Would someone please show me how to change this query to correct this issue?
SELECT
[22 TBL].CASE,
[22 TBL].AMT1,
[22 TBL].AMT2,
Sum([22 TBL].AMT1+[22 TBL].AMT2) AS [FINAL AMT] INTO [23 TBL]
FROM [22 TBL]
GROUP BY [22 TBL].CASE, [22 TBL].AMT1, [22 TBL].AMT2;
CASE____________AMT1_____________AMT2___________FINAL AMT
00652490P_______$1,622.25________$1,622.25________$3,244.50
00735400P_______$1,560.00_______________________________
00981230P_______$1,900.00_______________________________
