Update Query Help

[sross]

I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3.
Any help would be greatly appreciated so frustrated.

 

[pbaldy]

What have you got so far?

 

[sross]

I was trying it in sql but it isn't working...
Update file
Set working_addrl1 = addrl1
Thanks!

 

[pbaldy]

If file is the name of your table, that should work.

 

[sross]

It asks me for a parameter value for Working_Addrl1 - what should I enter here? And the file name is not file - it ends up in [] when I do the query. Should I remove these? Thanks again.

 

[pbaldy]

The parameter prompt is Access saying it can't find something, so double check the spelling. Perhaps it's a space, not an underscore?

Where you have "file" needs to be the name of the table.

 

[sross]

UPDATE [2013-P3 Data]
SET WORKING_ADDL1 = ADDRL1

This is what I have (thanks had a spelling mistake). It looks like it's working in the query but why can't I see it in the main file? How do I do that?

 

[pbaldy]

You mean table? Can you post the db here?