Hey guys, I hope you can help me out with a small question. Before I explain my situation I have to say I'm relatively new to access and haven't discovered most of its possibilities yet (for example using SQL).
Ok this is the situation: I have three database tables; The first database (X) is from 2010 with 1500 rows, the second database (Y) is from 2007 with 40.000 rows and the thirth database (Z) is from 2003 with 85.000 rows. All three databases have corresponding relationnumbers (and other information which concerns me like buildingyears, brands and types, but that isn't relevant for this question). So table Y has 1500 rows that are corresponding with 1500 of the 40.000 rows in table X, and table Z has 40.000 rows that are corresponding with 40.000 of the 85.000 rows in table Y. All three databases have the same format, but some information has been changed since 2003.
Now I want to create a new table (or query) in which I get to see the most recent information per relationnumber. So, at the end, I need to have one table with 1500 rows of data from 2010, 40.000 rows of data from 2007 and 43.500 rows of data from 2003, as a matter of speaking. What should I do?
I hope I've made myself clear and I would really appreciate it if someone could take the time to help me out and explain what I have to do step by step!
Thanks in advance!