base query sum(amt) returns null value if not rows match

[BillT]

have a query that sums a column but if no match returns null instead of value 0. This causes a follow up query to fail which uses that output

[gkick]

Hi,

you can use COALESCE e.g. SELECT SUM( COALESCE ( “sales”, 0 ) ) “Revenue” FROM “tblSales”

[BillT]

I tried answer 1 above. It simply returns a table with no values I am looking for a row to be return with the number zero in the field. Any suggestions would be appreciated.

[gkick]

Just take the sum out and you see all values 0 inclusive
COALESCE(“yourfield”,0)