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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Merry Widow - 01 Feb 2006 21:21 GMT

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.

Reply to this Message

Rick B - 01 Feb 2006 21:29 GMT

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]

Signature

Rick B

>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.

Reply to this Message