I have a sheet that updates from an access database. I'm using the following
to bring a sum of sales for a date range. Some times, there may not be any
records for that range and I would like it to show 0 instead of an empty
cell. Here is my code.

Thanks.

SELECT Sum(`51002`.Total) AS '5-1002'
FROM `\\web\web sites\lf\fpdb\mylf`.`51002` `51002`
WHERE (`51002`.Date1 Between ? And ?)