How do you keep One to Many Relationship with Parameter Field

[precious]

I have a "Left Outer Join" SQL statement linking an "Apartment" table and "Resident" table from an Access Database.

The report runs fine in Crystal Reports, it prints all apartment numbers out even if there are no residents for that apartment. However, when I add a date range parameter to the report and the report selects the correct "Residents" by date it no longer displays the "Apartment Number" for the records without residents.

Does anyone have a solution?

 

[kenhamady]

See the answer in your other post. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)