Hi,

Can somebody help me with my issue ?
I have two excel workbooks :
1. Detailled invoice overview per cell phone users
2. Payment report of the Accounting Department
I have no idea how I can match up payments from 2 against my first sheet.
If the sheet wasn't so big I would do it manually.
But I am sure somebody has a faster trick.
The field that corresponds in both workbooks is the invoice number.
I want the payment details from 2 to show up in the columns after these of my first sheet. Some invoices have not been paid and wouldn't have a match.

Any hint ?

Thanks in advance,
Dbase Beginner

You need to either link to the spreadsheets or import them. Then you can write queries that join the two tables. Use the query builder to create a query. Choose the two tables from the first dialog box and close it. Draw a join line between the Invoice fields in the two tables. Then select the columns you want from each table. If you want to see invoices even if there is no payment detail, change the join type to an outer join. Double click on the center of the join line and choose either option 2 or option 3 depending on which order you added the tables to the grid.

A word of caution...
If the database has the linked table "open", you can't open the spreadsheet via other means.
Depending on what you're doing, strange problems can occur.

Sarge.