Copy field data to a different field on the same table

[MariaVW]

Hello,
I am looking to get help in copying field data information into another
field on the same table.
For example I enter data in Field1 and it copies automatically into Field2.
Can it be done?

I know the risk of redundancy, but is a formating issue when connecting to
queries in other databases, doesn't like the formating this field has.

Thanks!

Maria

 

[Douglas J. Steele]

Rather than storing the data redundantly, why not create a query that
formats the data as necessary, and use the query wherever you would
otherwise have used the table?

 

[MariaVW]

Thanks for your suggestion, however, I need to store the data in the same
table.
The database itself is not big, therefore, no size or redunduncy concerns.

I don't own the database, so, I can only do certain alteration to it. I was
authorized to copy the field data into another field.

Can you or someone help me? I greatly appreciate your support.

Maria

 

[Douglas J. Steele]

Assuming you're using a form, you can automatically copy the value from
Field1 to Field2 in Field1's AfterUpdate event.

There's nothing you can do if you're working directly with the table.

The reason to be concerned with redundant data is if the two fields
disagree, how do you know which one is correct? You've offered no
explanation as to why a query with the data would not suffice.

 

[MariaVW]

Thanks you, Douglas.

You answer my question, sorry if I haven't provided you with all the
requirede information.
To clear the issue the data is being input in a table, therefore, there is
no solution but to create a query to perform the copying of the field.

THANK YOU!!!