Access ADP Report problem

  • Thread starter Thread starter robertm600635
  • Start date Start date
R

robertm600635

I have a report that displays fees and payments for a given client. The
report uses 2 tables, tblFees and tblPayments. tblFees has FeeID for the PK
and FeeID is the FK in tblPayments. The report lists all the clients fees and
a subreport lists the related payments. My problem is that if there is a row
in tblFees that doesnt have any related rows in tblPayments, the report does
not display that fee. Anyone have a solution for this?
 
Quite probably that you should use a Left Outer Join instead of an ordinary
Inner Join. However, without any detail about your query(ies), it's hard to
say.

Also, the official newsgroup for ADP is
microsoft.public.access.adp.sqlserver

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Back
Top