query returning 0 as a result

[Pat Buscio]

Hi, I have the following query

SELECT `tblCurrentWinStreak`.`PlayerID` AS PlayerID_1, If(`currentWinStreak` ="0", "Lost " & `currentLossStreak`, "Won " & `currentWinStreak`) AS `CurrentStreak`
FROM `tblCurrentWinStreak` INNER JOIN `tblCurrentLossStreak` ON `tblCurrentWinStreak`.`PlayerID` = `tblCurrentLossStreak`.`PlayerID`
GROUP BY `tblCurrentWinStreak`.`PlayerID`, `tblCurrentWinStreak`.`currentWinStreak`, `tblCurrentLossStreak`.`currentLossStreak`;

When i run it i get all the players names but 0 as the currentstreak. It should say won or lost and then a number. if i take out the & currentlossstreak and the & currentwinstreak, i get a result of won or lost which is correct. how do i get the number to also show? i set the number field in each table i am using to text. any thoughts would be helpful.

Thanks