Re: Another trim problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Evi" <evwool@xxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 30 Apr 2008 13:57:11 GMT

Use Instr to find the space then Left to get the name string

InStr([DistName], " ") finds the space so

Left([DistName, InStr([DistName], " ")-1)
Evi
"Golfinray" <Golfinray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E810F436-6B52-4744-AD7B-2C17D3B1932B@xxxxxxxxxxxxxxxx

I have 250 school districts in my district field. All of them say Jones
School District or Smith School District. I want to return just the Jones

Smith and not the school district. Thanks, so much!!!

Follow-Ups:
- Re: Another trim problem
  - From: KARL DEWEY

References:
- Another trim problem
  - From: Golfinray

Prev by Date: Query Criteria
Next by Date: RE: using a vairable in expression builder
Previous by thread: Another trim problem
Next by thread: Re: Another trim problem
Index(es):
- Date
- Thread

Relevant Pages

Re: JCT Not Available
... School District of Palm Beach County ... Parse Var numtype std cobol display /* NUMBER returns a string of 3 ... 'ISREDIT SEEK' fndparm 'FIRST' /* First see if there is a string ...
(bit.listserv.ibm-main)
Another trim problem
... I have 250 school districts in my district field. ... All of them say Jones ... School District or Smith School District. ...
(microsoft.public.access.queries)
Re: Another trim problem
... KARL DEWEY ... "Evi" wrote: ... School District or Smith School District. ...
(microsoft.public.access.queries)