Table or Query? Please Help on Access

[crcastilla]

Hi I don't how to accomplish this but I know there is a way. Let's say this; I have four tables(each table representing an item) and each of them has the following fields: SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature. I will be adding new records to each table each two weeks or about so.
Now I want a single table having information from each of these four tables. I want the latest record of each table to be there. So it would look sort of like this.

Here is...
Table 1 SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature
Table 2 SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature


Table 3 SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature
Table 4 SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature

Here is the single table I want..

SSN#, Action Taken, By, Date, Due Date; These would be the fields of the single table. All tables have these fields.
NOW. Each record below I would need to have the information from each table uhmm more like each record would represent the latest record in the respectively table. Does anyone understand what I want or howto do it? Please I have been trying to figure it out but I can't. Please anyone help.

[Bob Fitz]

Hi

I have responded to this question in another forum
http://www.access-programmers.co.uk/...d.php?t=214452