sum query is dumping out 0 dollar amount

[Mhypertext]

the below query keeps removing Issuedto Id if there is a 0 amount how do i get it to disply the results even if there is a 0 amount

SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount) AS SumOfSumOfAmount
FROM [qRY_AllComps04-01-09to06-31-09]
GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

 

[ajetrumpet]

the below query keeps removing Issuedto Id if there is a 0 amount how do i get it to disply the results even if there is a 0 amount

SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount) AS SumOfSumOfAmount
FROM [qRY_AllComps04-01-09to06-31-09]
GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

maybe the format function would help?


SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, FORMAT(Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount), "###,###,##0") AS SumOfSumOfAmount
FROM [qRY_AllComps04-01-09to06-31-09]
GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

 

[Mhypertext]

maybe the format function would help?


SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, FORMAT(Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount), "###,###,##0") AS SumOfSumOfAmount
FROM [qRY_AllComps04-01-09to06-31-09]
GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

its still dumping the 0.00 amounts


SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, FORMAT(Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount), "###,###,##0.00") AS SumOfSumOfAmount
FROM [qRY_AllComps04-01-09to06-31-09]
GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

 

[Mhypertext]

it looks like its keeping the 0.00 amounts now how ever when i i run the next query it dumps them

SELECT [qRY_Comps4-1-9to6-31-9].IssuedTo AS [Player ID], dbo_Player.FirstName, dbo_Player.LastName, [HostPlay4-1-9to6-31-9].[Host Name], Sum([HostPlay4-1-9to6-31-9].TotalTheoWinSum) AS TotalTheoWinSum, [qRY_Comps4-1-9to6-31-9].sumOfSumOfAmount AS [Comps Used]
FROM dbo_Player INNER JOIN ([qRY_Comps4-1-9to6-31-9] INNER JOIN [HostPlay4-1-9to6-31-9] ON [qRY_Comps4-1-9to6-31-9].IssuedTo = [HostPlay4-1-9to6-31-9].[Player ID]) ON dbo_Player.PlayerId = [HostPlay4-1-9to6-31-9].[Player ID]
GROUP BY [qRY_Comps4-1-9to6-31-9].IssuedTo, dbo_Player.FirstName, dbo_Player.LastName, [HostPlay4-1-9to6-31-9].[Host Name], [qRY_Comps4-1-9to6-31-9].sumOfSumOfAmount;