set up a field to duplicate info from another field in same table.

[Guest]

How do I set up a field in access table to duplicate the info found from
another field in the same table and record? Ex. Property Address, mailing
address. Most of the time the mailing address is the same, but not always.
Thanks

 

[Jeff Boyce]

It is rarely desireable to have multiple instances of the same data in the
same record, but your situation may be one of those. (Another alternative,
by the way, would be to use an Address table to store addresses, and store
the AddressID in your [MailingAddress] and [ShippingAddress] fields.)

You could use an update query to set the value of one of these fields to the
value in another field.

Regards

Jeff Boyce
Microsoft Office/Access MVP