I have 2 crosstab queries each table has matching 'Customer no.' and 'ship to codes' fields but with different items #s. I would like to have a query that shows all items #s from both tables. I can only get one way or another not both to show. I tried using the link properties but it doesn't seen to work. Any ideas how can i combine the item #s in both queries and like i said the 'Cust No' and 'Ship to Code' would be in both tables so i can use them as links to each other.