First Character of First Name!

B

Bob

This script gives me (Title,First &Last Name) I am trying to get the first
name to show just the first Character their Initial, Half way down I have
marked with ERROR ,tried to add what I thought would give me their Initial
but I am getting a Huey Luey Dewy Error , Invalid Syntax
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") & IIf(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID="
& [tbOwnerID])="" Or
IsNull(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " "),""),1)<---ERROR &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))




Thanks in advance.........Bob Vance
 
J

Jeff Boyce

Bob

I'd probably use:

Left([FirstName],1)

Do you have a [FirstName] field?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

Bob

Jeff got this to work but cant get a space between First name and Last
Name....Thanx Bob

=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
Left(Nz(DLookUp("[OwnerFirstName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),1) &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))

Jeff Boyce said:
Bob

I'd probably use:

Left([FirstName],1)

Do you have a [FirstName] field?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Bob said:
This script gives me (Title,First &Last Name) I am trying to get the
first name to show just the first Character their Initial, Half way down
I have marked with ERROR ,tried to add what I thought would give me their
Initial but I am getting a Huey Luey Dewy Error , Invalid Syntax
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
IIf(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " "),""),1)<---ERROR &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))




Thanks in advance.........Bob Vance
Click to expand...
Click to expand...
 
J

Jeff Boyce

Bob

I misunderstood. Are you trying to get FirstName & MiddleInitial &
LastName? If so, one way would be:

=[FirstName] & " " & Left([MiddleName],1) & ". " & [LastName]

Or am I still misunderstanding...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Bob said:
Jeff got this to work but cant get a space between First name and Last
Name....Thanx Bob

=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
Left(Nz(DLookUp("[OwnerFirstName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),1) &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))

Jeff Boyce said:
Bob

I'd probably use:

Left([FirstName],1)

Do you have a [FirstName] field?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Bob said:
This script gives me (Title,First &Last Name) I am trying to get the
first name to show just the first Character their Initial, Half way down
I have marked with ERROR ,tried to add what I thought would give me
their Initial but I am getting a Huey Luey Dewy Error , Invalid Syntax
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
IIf(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " "),""),1)<---ERROR &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))




Thanks in advance.........Bob Vance
Click to expand...
Click to expand...
Click to expand...
 
B

Bob

Yes Jeff, OwnerTitle (Mr) OwnerFirstname (John) show as (J) and
OwnerLastName (Smith)
Mr J Smith,,,, But if it is a Syndicate say (Lucky Horse Syndicate) that
will be entered into OwnerLastName then OwnerLastName must be left align for
Postal address ei:
Mr J Smith
Lucky Horse Syndicate

Thanks for your help...............Bob

Jeff Boyce said:
Bob

I misunderstood. Are you trying to get FirstName & MiddleInitial &
LastName? If so, one way would be:

=[FirstName] & " " & Left([MiddleName],1) & ". " & [LastName]

Or am I still misunderstanding...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Bob said:
Jeff got this to work but cant get a space between First name and Last
Name....Thanx Bob

=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
Left(Nz(DLookUp("[OwnerFirstName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),1) &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))

Jeff Boyce said:
Bob

I'd probably use:

Left([FirstName],1)

Do you have a [FirstName] field?

Regards

Jeff Boyce
Microsoft Office/Access MVP




This script gives me (Title,First &Last Name) I am trying to get the
first name to show just the first Character their Initial, Half way
down I have marked with ERROR ,tried to add what I thought would give
me their Initial but I am getting a Huey Luey Dewy Error , Invalid
Syntax
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
IIf(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])="" Or
IsNull(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " "),""),1)<---ERROR &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))




Thanks in advance.........Bob Vance
Click to expand...
Click to expand...
Click to expand...
 
B

Bob

Jeff I added & (" ") but if I just have the last name showing I am getting a
gap then the name:
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
Left(Nz(DLookUp("[OwnerFirstName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),1) & (" ") &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))

Thanks....Bob

Bob said:
Yes Jeff, OwnerTitle (Mr) OwnerFirstname (John) show as (J) and
OwnerLastName (Smith)
Mr J Smith,,,, But if it is a Syndicate say (Lucky Horse Syndicate) that
will be entered into OwnerLastName then OwnerLastName must be left align
for Postal address ei:
Mr J Smith
Lucky Horse Syndicate

Thanks for your help...............Bob

Jeff Boyce said:
Bob

I misunderstood. Are you trying to get FirstName & MiddleInitial &
LastName? If so, one way would be:

=[FirstName] & " " & Left([MiddleName],1) & ". " & [LastName]

Or am I still misunderstanding...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Bob said:
Jeff got this to work but cant get a space between First name and Last
Name....Thanx Bob

=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])="" Or
IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
Left(Nz(DLookUp("[OwnerFirstName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),1) &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))

Bob

I'd probably use:

Left([FirstName],1)

Do you have a [FirstName] field?

Regards

Jeff Boyce
Microsoft Office/Access MVP




This script gives me (Title,First &Last Name) I am trying to get the
first name to show just the first Character their Initial, Half way
down I have marked with ERROR ,tried to add what I thought would give
me their Initial but I am getting a Huey Luey Dewy Error , Invalid
Syntax
=IIf(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" & [tbOwnerID])=""
Or IsNull(DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerTitle","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " ") &
IIf(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])="" Or
IsNull(DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerFirstName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]) & " "),""),1)<---ERROR &
IIf(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])="" Or
IsNull(DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID])),"",DLookUp("OwnerLastName","tblOwnerInfo","OwnerID=" &
[tbOwnerID]))




Thanks in advance.........Bob Vance
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Blank between Names! 1
Only want the first 3 letters to show 3
Incorporate a space into a string 11
Recordset is not updateable after adding a query 7
First 3 Letters in a text Box 6
Emailing Question from my DB 2
Adding a CC to email code! 7
True or False for SNP or PDF format to email 12

Top