If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
combine last name and first name
I have the employee name separated by LastName & FirstName (2 separate
columns) in my TblEmployee. In my report, would like to combine the last and first names into 1 column... ex. Smith, John How do I do this? Thanks, Bob76 |
#2
|
|||
|
|||
combine last name and first name
Set the Control Source of the text box to:
=[LastName] & ", " + [FirstName] Make sure the Name property of this text box is not the same as a field, e.g. it cannot be Lastname or FirstName -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bob76" wrote in message ... I have the employee name separated by LastName & FirstName (2 separate columns) in my TblEmployee. In my report, would like to combine the last and first names into 1 column... ex. Smith, John How do I do this? Thanks, Bob76 |
#3
|
|||
|
|||
combine last name and first name
Thanks a lot... after several errors, finally did it... am a novice at
Access, just learning from books and help from this Discussion Group. Have another question: the report view shows the data in boxes, while the labels are not in boxes.. I want them to print out like a spreadsheet... Went to Design view and selected both the labels and data, but the GRIDLINES option in the Ribbon is grayed out.. Please help Thanks, BOB76 "Allen Browne" wrote: Set the Control Source of the text box to: =[LastName] & ", " + [FirstName] Make sure the Name property of this text box is not the same as a field, e.g. it cannot be Lastname or FirstName -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bob76" wrote in message ... I have the employee name separated by LastName & FirstName (2 separate columns) in my TblEmployee. In my report, would like to combine the last and first names into 1 column... ex. Smith, John How do I do this? Thanks, Bob76 |
#4
|
|||
|
|||
combine last name and first name
Select all the boxes (click and hold outside them, and drag over them), and
use the Line Color icon (towards the right on the Controls chunk of the Design ribbon.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bob76" wrote in message ... Thanks a lot... after several errors, finally did it... am a novice at Access, just learning from books and help from this Discussion Group. Have another question: the report view shows the data in boxes, while the labels are not in boxes.. I want them to print out like a spreadsheet... |
#5
|
|||
|
|||
combine last name and first name
That's great, Allen.... Did it.... thanks a lot
"Allen Browne" wrote: Select all the boxes (click and hold outside them, and drag over them), and use the Line Color icon (towards the right on the Controls chunk of the Design ribbon.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bob76" wrote in message ... Thanks a lot... after several errors, finally did it... am a novice at Access, just learning from books and help from this Discussion Group. Have another question: the report view shows the data in boxes, while the labels are not in boxes.. I want them to print out like a spreadsheet... |
Thread Tools | |
Display Modes | |
|
|