Using Windows 7,
Access 2010.
Is there a way to combine four fields into one field in the same record? I’m trying to build Equipment Code field by using the abbreviated values of Category, Item, Type and Dimension fields.
Example: if Category=Storage System (SS), Item=Wire Deck (WD), Type=Flared...