how to append data into sub table

G

geek

hi,
i need some help in appending the data into sub table. i have a table
which is used to store details on the inventory. the other sub-table is used
to store the quantities issued out and received, and the closing balance.

i wan to append zeros to the records which have no quantities issued out
and received in as those with no records wont appear in the report.

please help. thanks!
 
J

John Vinson

hi,
i need some help in appending the data into sub table. i have a table
which is used to store details on the inventory. the other sub-table is used
to store the quantities issued out and received, and the closing balance.

i wan to append zeros to the records which have no quantities issued out
and received in as those with no records wont appear in the report.
Click to expand...

It's probably NOT necessary to do so. Instead, base your Report on a
query using a "Left Join" - rather than joining the main table to the
subtable using the default Inner Join, which requires that records
exist in both tables, select the join line and choose option 2 - "Show
all records in maintable and matching records in subtable".

This will let you generate the report regardless of the existance of
the subtable records (they will be shown with NULL values in all
fields).

John W. Vinson[MVP]
 
Top