Hi,
as everybody says 'I am newby in Access', so am I. I need help with a code. The scenario is:
I have a Master table and Number of tables (Table1, Table2, etc.), which is changeable. For example let's say I have 5 tables. Those tables consist only part of Master table records, but they are not the same. So, what I need is to be able to open Master table and go through all its records and check which ones exist in Table 1. If they exist, add the Table1 records' values to the Master table records values. Same for the rest of the tables, but always add the records values, if they exist. And this is for all tables.
Thanks in advance for your help Gurus.

Cheers,

Yoff

Welcome to AWF. Now the bad news - I hate to be so blunt but it sounds like your database design is flawed. Why do you have multiple tables like that which have part of the master table information? What does that give you that just using Queries from the master table wouldn't?

OK,

I should probably explain what my target is. I want to build a report, based on those 5, 10 or Number of tables. I was thinking to combine them in a Master table and use it for my report source. I need to combine all records from those tables (if a record exists in more than one table, I need to add the values). As you can see, I am struggling with the code. Any help or ideas would be appreciated.

Thanks,

Yoff