insert into error

[jscriptor09]

Hi folks

I a have 2 tables A and B
Table A has 2 fields:
Date as in 01/01/2011
YR_FW as in 2011.01

Table B has many Fields but one of them is a Date

Problem:
I have a VBA to add a YR_FW field table B
Then I do this in VBA

"INSERT INTO B B.YR_FW Values (SELECT A.YR_FW FROM A WHERE B.Date = A.Date)"

I keep getting this error ""Syntax error in INSERT INTO statement."
Error number 3134

Any idea what am I doing wrong?



Thanks
Mike

[ssanfu]

I'm not really understanding what you are doing, but one problem is that "Date" is a reserved word in Access (and also a function name) and shouldn't be used for object names. Also, it is not very descriptive... "date" of what???

If you must use "Date" as a field name, try enclosing it in brackets:

INSERT INTO B B.YR_FW Values (SELECT A.YR_FW FROM A WHERE B.[Date] = A.[Date])