Sleeper: Merge 4 tables and sum corresponding items

[RuneDefour]

4 files are imported from Excel to access. after that I need a form where I can search for an article in those 4 tables. if there is an article in 2 tables, the amount must be added.
how should i do this? I have no idea how to start with that

[Aussiebear]

This thread is currently closed. RuneDefour, you have a number of threads which require your attention. Namely you need to indicate whether they are solved or not. Please go to each thread and either continue the conversation or mark them as solved. I require you do so within the next 24 hours