data from one table to another.

[Steve_in_Kent]

I want one table column to look up data in another column.. and i thought this would work, but it doesn't !

SELECT [LkupDATES].[CINCOMWEEK] FROM LkupDATES WHERE VOLUME.[PRODUCTION DATE]=LkupDATES.myDATE;

LkupDATES and Volume are the tables

cincomweek is the Text field i want to place in the new table column.

production date and myDate are date fields that match to determine what cincomweek to place in the new table.

Steve

[HansV]

If it's lookup information, why do you want to store it in a table? That would be redundant. You can retrieve the value at any moment using a query.

[Steve_in_Kent]

Yes, i know its not optimal to do so. but i just need the one table to contain information from the other table based on the dates.

[HansV]

Then you need an update query:

UPDATE VOLUME INNER JOIN LkupDATES ON VOLUME.[PRODUCTION DATE]=LkupDATES.myDATE SET VOLUME.CINCOMWEEK=LkupDATES.CINCOMWEEK

assuming that the field is named CINCOMWEEK in both tables.

[StuartR]

...i just need the one table to contain information from the other table based on the dates.

I am curious.

What is the real underlying "need" here. I would be very surprised if it cannot be met with a different solution that doesn't copy data between tables.