newbie question(s)

[Brad]

I have a first name field and a last name field. I want it to print as
though it were one field with first and last names. IOW, with all the last
names starting one space after the first name, not with all the last names
starting in the same column. Is this possible, or do I have to create
another field with both names? Thanks for any help.

Brad

 

[Gina]

In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

 

[Duane Hookom]

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



--
Duane Hookom
MS Access MVP

In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

I have a first name field and a last name field. I want it to print as
though it were one field with first and last names. IOW, with all the last
names starting one space after the first name, not with all the last names
starting in the same column. Is this possible, or do I have to create
another field with both names? Thanks for any help.

Brad

 

[Gina]

Thanks... must be time to turn in for the night

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



--
Duane Hookom
MS Access MVP

In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

I have a first name field and a last name field. I want it to print as
though it were one field with first and last names. IOW, with all the last
names starting one space after the first name, not with all the last names
starting in the same column. Is this possible, or do I have to create
another field with both names? Thanks for any help.

Brad

 

[Brad]

Gina and Duane,

Thanks very much. It worked, of course, + I learned something new about
Access. I just started using it a few days ago, so I'll be following up
soon with more questions.

Brad

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



--
Duane Hookom
MS Access MVP

In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

I have a first name field and a last name field. I want it to print as
though it were one field with first and last names. IOW, with all the last
names starting one space after the first name, not with all the last names
starting in the same column. Is this possible, or do I have to create
another field with both names? Thanks for any help.

Brad