Concatenate not working

[DrSmyth]

Hi,

I appear to be having a few problems with what should be a simple concatenation function. I can't seem to get this to work:

Name of PSM: RTrim([LLPSC01S_PSC_PSC_PSM_V]![PSM_FRNM]) & " " & RTrim([LLPSC01S_PSC_PSC_PSM_V]![PSM_SRNM])

it only brings back a value for one of the items in the [LLPSC01S_PSC_PSC_PSM_V] table, leaving the rest blank. However if i use the concatenated fields seperately I have no problem..

Help!!!!

 

[dhookom]

Have you tried any other fields to see if they behave the same? How about trying:

Name of PSM: Trim([LLPSC01S_PSC_PSC_PSM_V]![PSM_FRNM]) & " " & Trim([LLPSC01S_PSC_PSC_PSM_V]![PSM_SRNM])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[DrSmyth]

dhookom, I have another concatenated field that works fine:

Decesed: RTrim([LLPSC01S_PSC_PSC_ESTA_V]![SRNM]) & ", " & RTrim([LLPSC01S_PSC_PSC_ESTA_V]![FRNM])

Have also tried your suggestion and am getting the same results as i was before.... This is turning into a bit of a brain teaser!!!

Not sure if it's relevant but i'm using access '97

Andy

 

[PHV]

Obviously, you haven't altered the properties of [Name of PSM] to restrict it's length ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Melagan]

1)
Take one thing out of the equation - what happens when you do this?

Name of PSM: [LLPSC01S_PSC_PSC_PSM_V]![PSM_FRNM] & " " & [LLPSC01S_PSC_PSC_PSM_V]![PSM_SRNM]

2)
I can't tell for sure, but it looks like "LLPSC01S_PSC_PSC_PSM_V" is a table and not a form, therefor shouldn't you use the DOT notation in SQL?
i.e.

Name of PSM: Trim([LLPSC01S_PSC_PSC_PSM_V].[PSM_FRNM]) & " " & Trim([LLPSC01S_PSC_PSC_PSM_V].[PSM_SRNM])

~Melagan
______
"It's never too late to become what you might have been.