Try something like:
SELECT Sum([fielda]) AS FIELD1
FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.ID=TABLE2.ID;
I don't know what else to suggest without you providing more field and
filtering information.
--
Duane Hookom
Microsoft Access MVP
mccoy said:
when the details on TABLE2 has no records which is my subform, the RECORDS in
TABLE1 doesnt show on my report
Duane Hookom said:
What is your exact SQL view? Which table do you want to see all values?
--
Duane Hookom
Microsoft Access MVP
:
i tried all the three options but still doesnt have the zero records from
other table
:
Double-click the join line while in design view. Select the appropriate of
the three options.
--
Duane Hookom
Microsoft Access MVP
:
what do u mean by include all what sql code should i use
thanks
:
Change the JOIN to include all the records from one of the tables.
--
Duane Hookom
Microsoft Access MVP
:
i make a report from a sql source with a JOIN table but the details show only
a record with data from the other table it doesnt show the record with null
or zero values
can any1 help me what is the correct sql for this
Sum([fielda]) AS FIELD1 FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.ID=TABLE2.ID
