CR 6 - Urgent Inquiry

[jaisol]

We have to tables: 1)Sales and 2)Customers.
The tables are relationated by the Customer_ID field.

The report show only the customers with sales <> 0 and this is ok
but now we need that all the customers appear into the
report including too the customers without sales (sales = 0).

It is possible? How can we do that?

We really appreciate any response. THANKS.

 

[balves]

Go into the Visual Linking Expert and change the type of JOIN between the Customer and Sales tables. Make it a LEFT JOIN from the Customer table to the Sales table. You'll get ALL of the Customers and whatever matching Sales records there are for each Customer Id. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer