I have a table in Access where the first field is an Interger field called "Loan_id". I have added another field to the same table which is a text field called "cLoan_id".
I want to copy all contents of the Loan_id field into the cLoan_id field so that I have the same information in both fields with the exception of the cLoan_id field being a text field.
How can I do this? I appreciate any advice. If there is some kind of query I could do, what would the query actualy look like when it's constructed.
Am new to Access. :-(
Shawn.
I want to copy all contents of the Loan_id field into the cLoan_id field so that I have the same information in both fields with the exception of the cLoan_id field being a text field.
How can I do this? I appreciate any advice. If there is some kind of query I could do, what would the query actualy look like when it's constructed.
Am new to Access. :-(
Shawn.
