Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers with a sales figure in the first quarter(file,column) necessarily have an entry in any/all of the other three quarters(files,columns)
I cannot find a satisfactory method to join all 4 files so that i get all the information from each of the 4 files on my Report.
Any Help Appreciated
February 2, 2011 1:02 AM
February 7, 2011 6:00 PM