To add a record to a table from a select statement

[Kesh]

Access 2007
I want to add a date to a column in a table which contains dates only from another table which contains 1 date only. I am trying to use the following sql statement but I am getting a syntax error

INSERT INTO (([Arrears Frequency - Date] ( Date_Range ))
(SELECT RunDate.RunDate FROM [Arrears Frequency - Date], RunDate)

I am still a newbie on access. Any help will be much appreciated

Thank you

Kesh

 

[Kesh]

Thank you Pat for the advice on naming standards, I will take good note of it

 

[Kesh]

Hi All,
I used the following and it worked

INSERT INTO TABLE A ( Field A )
SELECT Table B.Field B
FROM Table B;

Thank you All
Kesh