NewDeal Hot Tip 1302NewFile
FIRST_NAME&" "&LAST_NAMEThat should do it. It can be confusing to use carriage returns inside a concatenated field, so I recommend that you use a different field for each line of your label layout.
Since NewFile doesn't have a global recalculation feature, you'll need to edit the FIRST_NAME or LAST_NAME field in each existing record to force the calculation to take place, of course. New records will be calculated when they are created. If your database doesn't have extensive layout work, you could export the data to NewCalc, add the calculated field there, where it will be recalculated automatically, and then import the data back into NewFile.
Last Modified 2 Mar 1999