I am using a select query to sum 2 fields in another select query, but if their are no records and the first select is empty I get a blank. I would like to get a zero if this happens. is this possible?

I am using Access 2007

select query 1
SELECT Trans.[LABOR$], Trans.[LBR-COST$], Trans.[Close-Date]
FROM Trans
WHERE (((Trans.[Close-Date])=Date()-1) AND ((Trans.[LBR-TYPE])="CCB"));
...