IIF Sentence

Feb 17, 2006

Now lets see some magic...

I have to tables, where if data in one field is in both tables I don't want the row to be shown in my query.
I have triede with a IIf sentence, but I can't get it to work.

Any ideas??

View Replies


ADVERTISEMENT

Word/Sentence Searching With % Matches

Apr 12, 2007

What I am trying to do is split a sentence into words LikeJocelyne Labylle And Jacob DesvarieuxThis would produce 4 words as the and,&,/ Ect are removedSo I end up with:-JocelyneLabylleJacobDesvarieuxIf all 4 words are found in a string it returns all matching records plus gets 100%3 words again returns all matching records plus say 75% and so onI haven't done a lot with it at the min as the first bit is quite simple IE getting the names Etc. but I can't think for the life of me how I can do the search.I Have Tried a query With [Names] Like ""*[String Names]*""" but it seems to only work with each letter???but my main reason for asking here is I don't like reinventing the wheel or at least trying to which will mean hours of Fun but maybe somebody knows of something I could use on the net.Thanks for any help/Advice.mick

View 5 Replies View Related

General :: Using Wildcards To Find Number In A Sentence

Mar 4, 2013

I should find the position of a number in a sentence and later extracted. The number is attached always to an "E". ie: E1, E2, E3,E4. The range of the number is 1-4. I have this until now:

X: InStr("E[#]",[Col1_Comment_1])

but it always return 0

View 5 Replies View Related

Modules & VBA :: Web Page Template - Adding Characters Before And After Sentence

May 6, 2014

I'm using Access to create some web page templates. To Do this I have a memo field called "Description" into which I'm entering text. Example:

This is an obvious description example

What I need to be able to do is put a "<p>" before each sentence and a "</p>" at the end of each sentence. Examle

<p>This is an obvious description example</p>

The information is stored in a form page, and the text have paragraphs.

View 1 Replies View Related

Reports :: Generate A Report For Items In Previous Sentence Not Completed To Keep Track Of Workload

Jul 29, 2013

I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved