what is wrong with this text expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having the
wrong number of arguments. i have checked and 2ble checked the help doc'n and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care to
disabuse this writer?
 
Ted,

Try using Left() function

Initials: Left([First Name],1) & Left([Last Name],1)

Brian
 
Oops. Make that...

Initials: Right([First Name],1) & Right([Last Name],1)

--
Rick B



Rick B said:
I would use...

Initials: Right([First Name],2) & Right([Last Name],2)



--
Rick B



Ted said:
i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having
the
wrong number of arguments. i have checked and 2ble checked the help doc'n
and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care
to
disabuse this writer?
Click to expand...
Click to expand...
 
whooosh, that's what i _meant_ to write. thanks for the reality checkup,
brian :-)

Brian Bastl said:
Ted,

Try using Left() function

Initials: Left([First Name],1) & Left([Last Name],1)

Brian


Ted said:
i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having the
wrong number of arguments. i have checked and 2ble checked the help doc'n and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care to
disabuse this writer?
Click to expand...
Click to expand...
 
Sorry, Ted, there's no such Access function as Last().

Maybe you mean Excel.

Or maybe you mean Right([First Name],2) + Right([Last Name],2). Don't use '&'
here.

Sam
i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having the
wrong number of arguments. i have checked and 2ble checked the help doc'n and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care to
disabuse this writer?
Click to expand...
 
Wow! I am not paying attention at all today!!! Of course it would be the
Left digit, not the Right.

--
Rick B



Rick B said:
Oops. Make that...

Initials: Right([First Name],1) & Right([Last Name],1)

--
Rick B



Rick B said:
I would use...

Initials: Right([First Name],2) & Right([Last Name],2)



--
Rick B



Ted said:
i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having
the
wrong number of arguments. i have checked and 2ble checked the help
doc'n and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care
to
disabuse this writer?
Click to expand...
Click to expand...
Click to expand...
 
Whoops, agreed.

Sam
Sorry, Ted, there's no such Access function as Last().

Maybe you mean Excel.

Or maybe you mean Right([First Name],2) + Right([Last Name],2). Don't use '&'
here.

Sam
i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:
Click to expand...
[quoted text clipped - 5 lines]
can't cee what i'm doing wrong. it's got to be really dumb. anybody care to
disabuse this writer?
Click to expand...
Click to expand...
 
That happens to me more than you know!

Brian


Rick B said:
Wow! I am not paying attention at all today!!! Of course it would be the
Left digit, not the Right.

--
Rick B



Rick B said:
Oops. Make that...

Initials: Right([First Name],1) & Right([Last Name],1)

--
Rick B



Rick B said:
I would use...

Initials: Right([First Name],2) & Right([Last Name],2)



--
Rick B



i want to create an 'Initials' field using Last name and First name. so i
entered this in my query:

Initials: Last([First Name],2) & Last([Last Name],2)

and it's returning an error message about the function i'm using having
the
wrong number of arguments. i have checked and 2ble checked the help
doc'n and
can't cee what i'm doing wrong. it's got to be really dumb. anybody care
to
disabuse this writer?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top