How do I copy data from one column to another?

[Dustin Ventin]

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

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[NetworkTrade]

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?

 

[Smartin]

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

Works for me exactly as written. What data types do you have in
ED_FlatCostPerUnit and ED_UnitRate?

 

[Dustin Ventin]

They are both Decimal type numbers to 2 decimal places of percision.

Dustin

 

[Dustin Ventin]

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