How do I copy data from one column to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to copy information from one column in a table to another. I've been
using this query:

UPDATE tblEstimateDetail SET tblEstimateDetail.ED_FlatCostPerUnit =
tblEstimateDetail.ED_UnitRate;

But nothing gets copied over.

Ideas?

Dustin
 
ignore the spam reply about 2004

in your 'need to copy' - - is this a one time event of you manipulating a
table? or do you need it to routinely occur at a specific event involving a
form unbeknownst to the user?
 
Dustin said:
I need to copy information from one column in a table to another. I've been
using this query:

UPDATE tblEstimateDetail SET tblEstimateDetail.ED_FlatCostPerUnit =
tblEstimateDetail.ED_UnitRate;

But nothing gets copied over.

Ideas?

Dustin
Click to expand...

Works for me exactly as written. What data types do you have in
ED_FlatCostPerUnit and ED_UnitRate?
 
The second one...I'm going to do a DoCmd.RunSQL statement for this code,
which runs then the user makes a certain choice my pressing a button.

Dustin
 
Back
Top