Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep Left Outer Join with parameter field

Status
Not open for further replies.

precious

Programmer
Mar 6, 2001
3
US
I have a "Left Outer Join" SQL statement for my "Access Database". When I create my Crystal Report it works great, however, when I add a parameter field to the report, the report comes back with the requested records as it should. But I want the first field in each record to appear in all rows whether or not the record matches the parameter field or not.

Please help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top