Re: Trim Initials from Name field
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Thu, 28 Dec 2006 23:52:59 GMT
Lacey wrote:
Hi All!
I have a table that contains a Name field. The name appears as
LastName,FirstName Initial, or sometimes just LastName,FirstName
(without any initial). There's no spacex between the LastName, comma
and FirstName.
Is there a way trim the initials from the Name field IF it has one
and NOT remove part of the First Name if it doesn't???
Please advise...
Left([Name], InStr(1, [Name], " ")-1)
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- Prev by Date: Re: Search Form Results
- Next by Date: RE: If Statement
- Previous by thread: Count(Distinct()) with multiple fields
- Next by thread: Re: Trim Initials from Name field
- Index(es):
