 | |
Concatenating Fields in Query
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Concatenating Fields in Query -
09-14-2011
, 05:23 AM
#2
| |||
| |||
|
|
I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? |
Greame), in other words is Brian Wright printing on 2 lines, and you are only
seeing the first line?
Phil
#3
| |||
| |||
|
|
On 14/09/2011 11:23:16, "Bob Darlington" wrote: I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? Have you got a line feed or carriage return after Brian ( but not after Greame), in other words is Brian Wright printing on 2 lines, and you are only seeing the first line? Phil |
#4
| |||
| |||
|
|
On 14/09/2011 11:23:16, "Bob Darlington" wrote: I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? Have you got a line feed or carriage return after Brian ( but not after Greame), in other words is Brian Wright printing on 2 lines, and you are only seeing the first line? Phil |
#5
| |||
| |||
|
|
What about some other unprintable character, such as a Null (Chr(0))? "Bob Darlington" wrote in message news:4e711af7$0$2444$afc38c87 (AT) news (DOT) optusnet.com.au... Good thought Phil. But no CR. -- Bob Darlington Brisbane "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in message news:j4q0d4$aj5$1 (AT) speranza (DOT) aioe.org... On 14/09/2011 11:23:16, "Bob Darlington" wrote: I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? Have you got a line feed or carriage return after Brian ( but not after Greame), in other words is Brian Wright printing on 2 lines, and you are only seeing the first line? Phil |
#6
| |||
| |||
|
|
On 14/09/2011 11:23:16, "Bob Darlington" wrote: I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? Have you got a line feed or carriage return after Brian ( but not after Greame), in other words is Brian Wright printing on 2 lines, and you are only seeing the first line? Phil |
#7
| |||
| |||
|
|
Thanks Douglas, That was it. There appears to be an extra character which looks like an underscore after the first name. It is not a space character, and is only visible when the whole field is selected (using F2). My problem now is to find how it got there and to prevent it happening again. Any ideas? -- Bob Darlington Brisbane "Douglas J Steele" <NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote in message news:j4rcfc$rp2$1 (AT) dont-email (DOT) me... What about some other unprintable character, such as a Null (Chr(0))? "Bob Darlington" wrote in message news:4e711af7$0$2444$afc38c87 (AT) news (DOT) optusnet.com.au... Good thought Phil. But no CR. -- Bob Darlington Brisbane "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in message news:j4q0d4$aj5$1 (AT) speranza (DOT) aioe.org... On 14/09/2011 11:23:16, "Bob Darlington" wrote: I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " & LastName. In the first instance I have: FirstName = Graeme LastName = Wright This results in a FullName of "Graeme Wright" which is fine. In a second case, I have FirstName = Brian LastName = Wright This results in a FullName of "Brian" instead of "Brian Wright". I feel I'm missing something obvious, but can someone let me know what it is? Have you got a line feed or carriage return after Brian ( but not after Greame), in other words is Brian Wright printing on 2 lines, and you are only seeing the first line? Phil |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.