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
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
Njliven -
In a query, you could try...
FN: [FName] & " " & IIf(IsNull([MInitial])=True,"",[MInitial] & ". ") & [LName]
All the best,
Jim
Thanks for the suggestion however, it is still not working. Any other suggestions?
What does this really mean
Are you trying to concatenate these?? Join has a whole different meaning in database.I am joining fields =[Fname] & " " & [Minitial]+". " & [LName]
Do you get an error?, it is still not working
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?
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.
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.
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)>
Good point Linq.
This one does the trick. Thanks!
Glad we could help!
Linq ;0)>