Hello, Hopefully there is a simple solution to this. I have two tables. One is customers, one is orders. Both share the key Customer ID. I have used the simple query wizard to create a query and selected fields from both tables. However the table that is produced is creating a new row for every order that a customer has placed. And thus duplicating customer details on every order row. This is not what I need. I need one row per customer. Some customers have 90 orders, and order details are about 9 fields, so I would like each customer row to have about 900 columns, called ORDER1, ORDER2, ORDER3, etc... Does this make sense? Please help if you can. Thanks, Gary.