Some database fields not showing in Report. why?

[tex4kkp]

Hello all, I have a tech Q.
I have a table [accountmgmt] (main table) and a table [schedule]. They both have the common field account_id.
Data is shown from the table accountmgmt only if its present in [schedule]. How do I show the data from [accountmgmt] even if there are no values from [schedule]? I dont care if it shows as zero values, but the account name needs to be shown.
Thanks in advance.

 

[synapsevampire]

Change the join to a Left Outer.

-k

 

[tex4kkp]

Thanks for the advice. I already tried that - no result - but I figured out that this wasnt the problem. I have a subreport linked by a common field in the main report[accountmgmt.externalID] to [Invoices.accountid] on a different database system. This doesnt seem to bring all the fields in because there are no details on the extrenal database. Any way to resolve this?