newbie question(s)

  • Thread starter Thread starter Brad
  • Start date Start date
B

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
 
In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.
 
Forgot a "]"
FullName: [FirstName] & " " & [LastName]



--
Duane Hookom
MS Access MVP


Gina said:
In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

Brad said:
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
Click to expand...
Click to expand...
 
Thanks... must be time to turn in for the night 8-)


Duane Hookom said:
Forgot a "]"
FullName: [FirstName] & " " & [LastName]



--
Duane Hookom
MS Access MVP


Gina said:
In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

Brad said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Duane Hookom said:
Forgot a "]"
FullName: [FirstName] & " " & [LastName]



--
Duane Hookom
MS Access MVP


Gina said:
In a queryon the table, top line, put

FullName: [FirstName&" "&[LastName]

in one field and that should do it.

Brad said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top