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 Chriss Miller 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
Joined
Mar 6, 2001
Messages
3
Location
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!
 
See the answer in the previous post. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top