Concatenate Fields

[Njliven]

I am joining fields =[Fname] & " " & [Minitial]+". " & [LName] This eliminates the (.)period and the extra space, when you do it directly in a form, but when I do the same thing in a query it does not work. Any suggestions?


Thanks

[ketbdnetbp]

Njliven -
In a query, you could try...

FN: [FName] & " " & IIf(IsNull([MInitial])=True,"",[MInitial] & ". ") & [LName]

All the best,

Jim

[Njliven]

Thanks for the suggestion however, it is still not working. Any other suggestions?

[orange]

What does this really mean

I am joining fields =[Fname] & " " & [Minitial]+". " & [LName]

Are you trying to concatenate these?? Join has a whole different meaning in database.

, it is still not working

Do you get an error?
Can you show us an example of
a)what you are using
b) what you want to see, and
c) what you are actually getting?

[Njliven]

On a form when combining the name fields, I used the + after the Minitial and it does not put the period and the extra space if the Minitial is null (which is what I want to happen).
However if I use the same formula in a query it just ignores it. When the Minital is null I get this: John . Doe I want to see John Doe.

[orange]

So you would really like some expression that will work in a query and a form.
My best guess

Query

Fullname: Iif(Len(MInitial) & "" = 0,FName & " " & LName, FName & MInitial & ". " & LName)

For the form control
=Iif(Len(MInitial) & "" = 0,FName & " " & LName, FName & MInitial & ". " & LName)

Good luck.

[Missinglinq]

=[Fname] & " " & [Minitial]+". " & [LName]

...I do the same thing in a query it does not work...

Are you actually using the exact same thing, in the Query, i.e.

=[Fname] & " " & [Minitial]+". " & [LName]

Because in the Query Design Grid you can use the same basic expression, but you have to drop the Equal Sign and give the Calculated Field a name, say 'FullName'

FullName:[Fname] & " " & [Minitial]+". " & [LName]

In the SQL Statement it would be

[Fname] & " " & [Minitial]+". " & [LName] AS FullName

Linq ;0)>

[orange]

Good point Linq.

[Njliven]

This one does the trick. Thanks!

[Missinglinq]

Glad we could help!

Linq ;0)>