Overview: I have 3 queries searching 3 different tables for 2 fields. I then have one combining query that adds the results of the 2 fields from the 3 queries. Each query finds records in the table that match a particular date. When the records are found each query returns the sum of the 2 fields in table. If one of the tables doesn't have any records that match the date, the combining query is blank, it doesn’t return the sum from other 2 queries . What I want to do is somewhere in the query to say that if no record is found then return zero in the fields. This formular is giving me some problems. Help Please.

So the queries are adding the numbers found in the 2 fields as long as the record contains a specified date? What fields do you want to contain a zero? What formula are you using, and in what field/query is it located? Life's more painless for the brainless.

Thanks for responding Jennifer. However, I used the nz function and it is working now.