I want to make a field be a formula, but I'm having trouble... basically I want to concatenate a bunch of fields to make one string so I don't have to do it programatically.
I have an address table that separates streetname, house, apt, lot, etc... but not every house has an apt or lot, for...