Copy info from one field to another.

[smpayne]

I have an access table where I want to copy the contents of an interger field called "Loan_ID" to a text field called "cLoan_id" within the same table.

Is this possible? If so, could someone show me how to do such a thing. I was thinking of an Update Query, but am so new to Access, I wouldn't know how to construct it.

Thanks!

 

[RichO]

Easy to do with an update query. Create a query in design mode with your table selected, from the Query menu select update query.

Select cLoan_ID as the only field and in the Update To box enter [Loan_ID], and then click on the red exclamation point in the toolbar.

 

[modest]

You should have posted this in the Query section of this forum.

UPDATE [Table Name] SET [cLoan_ID] = [Loan_ID];

 

[smpayne]

Perfect!

Thanks for your assistance!

 

[Rich]

Why would you want to?