I have two fields that use the lookup wizard and pull data from two separate tables.
Field 1 = Cable Location ID, Data Type = Autonumber
Field 2 = Cable Type, Data Type = Number (being used to query information from another table)
Field 3 = Location, Data Type = Number (being used to query information from another table)
Field 4 = Cable Type and Location, Data Type = Calculated
Ok in my Field 4 Calculated I have [Cable Type] & " in " & [Location] it results in "1 in 1" instead of "Cat 5 in Location" is there a way to fix that?
Thank you.