Forum Discussion
From Excel to Access - Match invoices
Hi, I used to use MS Access twenty+ years ago, but lost experience. I'm a heavy MS Excel user nowadays. I do have an issue which I can solve in MS Excel, but don't know how to in MS Access. Is...
It depends a lot on how you want to present the data. You could, in theory, create a query with all five tables, joined on the invoice-number. However, it's not clear whether that invoice-number is unique in each table, and if not, what the primary key values would be. Also, it depends partly on whether there are matching records in all tables. That would determine whether you need inner or outer joins.
Basically, though, if you can provide sample data, someone could take a shot at helping you crete the query. Use made up data, but make it realistic.
Thanks.
Basically, though, if you can provide sample data, someone could take a shot at helping you crete the query. Use made up data, but make it realistic.
Thanks.
Hi George, thank you for your reply. Don't know whether it is allowed here to attach .xls or one .zip file, but that would be great. I will prepare a real-life set - with blanked personal ID data.
- Yes,it is allowed to attach .xls or .zip file here.
Open full text editor then you can upload .zip file to.this forum.
