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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top