Make Table Query

[Samy]

Hi I have 2 tables saved in the same database. Table A has 2 fields (age and
ID). The other table, Table B has 49 fields, 1 being ID.

I need to combine all the data from the table A which has 49 fields with
only age from the table B. However, table B contains data for a lot more
patients but I want Access to only extract 'age' for the the number of
aptients I have data on in table A, using the ID field. Is this possible?

I am assuming that I have to create a make table query? Is this the correct
way of combing data? Also is a make table query the one I should be creating?

However, when I create a make tabkle query, after selecting which tables I
want data extracted from, it displays an 'Invalid Argument 3001 error.' What
does this error mean? I don't know what I'm doing wrong as this is my first
time using Access.

Please help.

 

[KARL DEWEY]

Try this --
SELECT [Table B].*, [Table A].[Age]
FROM [Table B] LEFT JOIN [Table A] ON [Table B].[ID = [Table A].[ID];