merge names tfrom a spread sheet to one page not a label

M

Merry Widow

i want to usse my list of stucents to make a list. they are in a spreadsheet
with first names in one column and second names in another.
i try to do this from a data base also and can't get it to work. my old 3.0
did a great job with this.
 
R

Rick B

Huh?

Are you using Microsoft Access? Access is a database, not a spreadsheet.

What is "my old 3.0"?

To combine first and last name in a database, you would use an unbound
textbox in a form or report. It would contain something like:
=[FirstName] & " " & [LastName]

You could also use...
=[LastName] & ", " & [FirstName]


To do this in a query, you'd have to add a new column and put something
like...
CombinedName: [FirstName] & " " & [LastName]
 
Top