PDA

View Full Version : Combining Two Fields into one


mlb24
October 23rd, 2002, 02:36 PM
Hello, I have two fields, a building number and a check number. Can I combine them into one field?

I'm trying to make a concatnated field, so when I export this into my database, I can make it the primary key. Thanks in advance

tnatividad
October 24th, 2002, 10:56 AM
MLB24,

make the data type for the bldg number and the check number as character, then use + in the calculated field, e.g. bldg #+"-"+check #. hope this helps......tony n