A query with fields from two tables

M

Michalis J.

I am using a query twith fields from two tables. I am using most of the
fields from the first table and a sum of a field from the second table. When
the period for which I run the query retuns no records from the second table
the query shows no results although the first table should give some results.
I am using the results of this query in a report where I need some
information from the first table and a sumary of a field from the second
table.
Does anybody have any idea how I can get the fields of the first table and a
zero for the sumary of the field of the second table. I have tried to use the
nz function in different places but still with no success.
Thanks in advance.
Michalis
 
D

Duane Hookom

Double-click the join line in the query design view. Set the join properties
to show all the records from the first table.
 
M

Michalis J.

Thank you very much for your responce Duane.
I should have mentioned that the two tables have no related fields.
If only I could make the sum of the field in that query give a zero outcome
when there are no records in the query the problem would be solved.
 
M

Michalis J.

The first table deals with the individual project expences of a constraction
company. The second table deals with the administration expences. In the
report for the individual project expences I want to have the summation of
the administrative expences as well, so as I can calculate the percentage of
the total expences.
 
Top