merge cells?

J

jackie

I want to make labels from info in my master database. i have a field for
last name and a field for first name. Is there a way to merge these cells
within a report, or is there an easy way to make labels from my data?
Jackie
 
A

Arvin Meyer

The process is called concatenation.

Create a third column in your query which underlies the label report and add
them together like:

FullName: [FirstName] & " " & [LastName]

or just do it in a textbox on the label:

=Trim([FirstName] & " " & [LastName])

The Trim() function will truncate any leading or trailing spaces.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top