I need to display a 0 (zero) in a Listbox instead of a blank. The RowSource is listed below. I've looked though some example such as NZ and Transform but this is NOT a crosstab query. Thank you in advance for any guidance
I asked this question before but only receieved a partial answer.
This answer gets me my value of zero. What happens when I have a result for this query besides 1 or zero. This answer only counts the result of the encapsulated query. Please advise
e.logid) AS BidCount
FROM FiscalMonthSelector INNER JOIN Tbl_Early_Ontime_Late ON FiscalMonthSelector.[Fisca
l Month Year] = Tbl_Early_Ontime_Late.Mont
WHERE (((Month([Report Month]))=Month(Now())) AND ((FiscalMonthSelector.Year
GROUP BY Tbl_Early_Ontime_Late.Cate