Kaoli wrote:
May I know what you mean left join Master to Child in the query?

If I understand what you want I think if you Left Join Master to Child in the
query it will function like you want.
[quoted text clipped - 27 lines]
I tried to solve and search solution in internet about 2 months, I really
hope anyone can help me this new user to solve this simple problem.


LEFT join means
"include ALL records in the "Left side" table, and only matching records in
the right side. So say you have the standard Customers and Invoices tables
joined on CustomerID...

SELECT Customer.CustName, Invoice.InvoiceNo
FROM Customer LEFT JOIN Invoice ON Customer.CustomerID = Invoice.CustID

will display ALL Customers regardless of whether they have any invoices, and
any invoices they may have. An INNER join will eliminate all customers from
the result set that have no Invoices.

--
Message posted via http://www.accessmonster.com