Using MSQuery To Bring Entries From Multiple Tables Together

[Pete81]

Hi,

I am trying to create, using MSQuery in Excel, a single table which shows all entries for a single customer over the year. These entries will come from 12 monthly tables, on separate worksheets within the same workbook.

However, I am having trouble joining the tables, as when I try to do so for just two of the 12 tables, the result is that the entries for the second table don't show, while the entries for the first are duplicated, sometimes as much as 8 times depending on which two I put together.

I honestly don't know where I'm going wrong, and would very much appreciate some advice on the matter.

Thank you.

Peter

 

[sheetspread]

The join will include all rows for a given value, so if they're not unique you can have many repeats

 

[Pete81]

Hi sheetspread,

Each table covers any issues for a customer on any of their orders. As each issue is unique, in either description, date and/or order number, each row entry should be unique. The problem I am having is that once I try to bring entries in from two monthly tables, I see duplications of row entries from the first month, and no entries at all from the second.

 

[sheetspread]

A much better data structure would be one table for all the customers, with a form to enter each new record. If you post your query, however, I can try to find the error.