place "0" in blank field
I'm trying to place a "0" in the count field of this query when the count field for a particular number is blank. Is this possible? Here's my query that gives me the correct results, but when a number has no counts it is BLANK instead having a "0" like I would like it.
SELECT DISTINCT tblNumbers.NUMBERS, qry1stNumbers.COUNT1
FROM tblNumbers LEFT JOIN qry1stNumbers ON tblNumbers.NUMBERS = qry1stNumbers.FIRST_BALL
GROUP BY tblNumbers.NUMBERS, qry1stNumbers.FIRST_BALL, qry1stNumbers.COUNT1;
Any help would be greatly appreciated.
Thanks,
Kacy
________
Buy Marijuana Seeds
I'm trying to place a "0" in the count field of this query when the count field for a particular number is blank. Is this possible? Here's my query that gives me the correct results, but when a number has no counts it is BLANK instead having a "0" like I would like it.
SELECT DISTINCT tblNumbers.NUMBERS, qry1stNumbers.COUNT1
FROM tblNumbers LEFT JOIN qry1stNumbers ON tblNumbers.NUMBERS = qry1stNumbers.FIRST_BALL
GROUP BY tblNumbers.NUMBERS, qry1stNumbers.FIRST_BALL, qry1stNumbers.COUNT1;
Any help would be greatly appreciated.
Thanks,
Kacy
________
Buy Marijuana Seeds
Last edited: