Delaut values in a query if no record in table

[DB03836]

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"));


select query 2
SELECT Sum(BSLaborDail y.[LABOR$]) AS [SumOfLABOR$], Sum(BSLaborDail y.[LBR-COST$]) AS [SumOfLBR-COST$]
FROM BSLaborDaily;

[FishVal]

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"));


select query 2
SELECT Sum(BSLaborDail y.[LABOR$]) AS [SumOfLABOR$], Sum(BSLaborDail y.[LBR-COST$]) AS [SumOfLBR-COST$]
FROM BSLaborDaily;

Hi!

Try to use the following SQL for the 2nd query

SELECT Nz(Sum(BSLaborD aily.[LABOR$]),0) AS [SumOfLABOR$], Nz(Sum(BSLaborD aily.[LBR-COST$]),0) AS [SumOfLBR-COST$]
FROM BSLaborDaily;