[log in to unmask] wrote: : David McConnachie asks: [snip] : All 3 files can be linked by one common file. : We have tried altering the weightings and outer join characteristics, : so far to no avail. Per my reply to the original post to the powerhouse list server I suggested that he look at using UNION ALL. -- Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707,Stn.T Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr. Cognos Incorporated Internet: [log in to unmask] Ottawa ON K1G 4K9 URL: http://www.cognos.com CANADA