[AccessD] FW: [U] Soldier in Iraq needs Access Help

How about  

LIKE "*IED*"  ----------  or more generically:  LIKE "*" & txtCriteria & "*"

instead of

LIKE "* IED *"  (leave out the spaces)

I do this in some queries and it picks things up at the beginning, middle,
or end.

Dan Waters



-----Original Message-----
Subject: Re: [AccessD] FW: [U] Soldier in Iraq needs Access Help

Rusty,

The only problem with this is IED is at the start of a sentence or is
followed by a period, commas, etc.

Bobby 

-----Original Message-----
Subject: Re: [AccessD] FW: [U] Soldier in Iraq needs Access Help

Rocky,

These ideas aren't what he's asking for but they might help him speed up his
search a little bit.

To help his search he could in a query put Like "* IED *" in the criteria of
his query.  That should only return those records where IED is surrounded by
spaces on either side thus not being part of another word.

Another option, which isn't as nice as the Google search he refers to, is to
flag each article that has an instance of IED via an update query, export
those flagged records out to a word document via a report, then run Find and
Replace in Word and use the "Highlight All Items Found In" option. I know
this option is found in Word 2003 and not in 97.  I don't about the versions
in between.

HTH,

Rusty


-----Original Message-----
Subject: [AccessD] FW: [U] Soldier in Iraq needs Access Help


Anyone want to tackle this one?  Sounds like an interesting project.

 

Rocky

 

 

Subject: [U] Soldier in Iraq needs Access Help

Classification: UNCLASSIFIED 

Greetings from Baghdad.

 

I am not one to ask for help until I have absolutely driven myself to the
edge. It is my hope that you or one of your experts can shed some light on
what I am trying to get Access to do.

 

There are actually two things, but first an explanation of what the database
does. A team of translators interpret local Iraqi newscasts which are
transcribed and input into the database. These transcriptions are referred
back to on a regular basis via requests to my office by the higher-ups. A
typical request would be along the lines of "Give me the instances over the
past two weeks Prime Minister Maliki has said he likes the U.S." or, "Give
me every article referring to IED's exploding in the past month"

 

A simple query of course, returns the date range and all articles whereas
the word "Maliki" appears. I am helped by the fact that Maliki does not
appear in the dictionary so I can scan through the articles, deleting those
that are not relevant. I cannot however discern when IED is actually part of
another word. 

 

What I would like to accomplish, is highlighting my text query, much like
Google does in its cached pages. So, those words that I search for are
highlighted, giving me a visual reference. 

 

I have tried constructing a macro to do the action and have also searched
high and low in the Help files and the Internet.. Perhaps this makes perfect
sense to you and you can point me in the right direction.

 

Thank you in advance for your time.

 

SFC Lester Newsom

Baghdad, Iraq