Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Search Terms
Andrew Fordred 
  
4 years ago
Hello Everyone
I have a table full of text from various media outlets (articles), a good couple of 1000s.

How would one setup a search to look through the table for specific keywords (about 70)?

I tried a query but it appears limited unless putting the search terms in another table and run the query against the original articles table?  Just not getting that to work.

Thanks

Andy
Scott Axton  @Reply  
        
4 years ago
Search Form 2.0 is a good place to start.
Much more in depth is the Access Search Seminar

To be honest though we need more information on the structure of your db an tables to go much farther.
Andrew Fordred OP  @Reply  
  
4 years ago
thanks for the link, it really looks like something I must do

there is one table with just over a 1000 articles (rows) i.e. the text of the article is stored in a Long Text

there is another table there are 70 keywords stored in short text each in their own row

trying to search those keywords against the articles table and only have a result that contains a row which contains article text matching the keyword
Scott Axton  @Reply  
        
4 years ago
It is actually a little difficult to search Long Text fields.  
In my mind your best bet is to set up a third Junction Table and relate the Article Record(s) to the Keyword Table.
That type of relationship is called a Many-to-Many
By your description I'm guessing that you could have one keyword related to many articles and one article could have multiple (or no) keywords.

If you are not familiar to Relationships check out this video first.

I see that at this point in time you don't have any of the courses under your belt so I don't know what your experience level is in order to point you to specific courses.  The best way would be to start t the beginning and don't skip levels any way.
Andrew Fordred OP  @Reply  
  
4 years ago
thanks, I just started working on a junction table as had the same thought along the lines of the many to many relationship exactly based on what you mention "could have one keyword related to many articles and one article could have multiple (or no) keywords".

I actually did several of Richard's courses some years ago and been using access since Windows 95 on a casual basis, have some idea to get by.

Thanks again let me try this
Andrew Fordred OP  @Reply  
  
4 years ago
Just some feedback, got it to work, but it is not pretty, the result is massive, but in case anyone else has a similar issue.

Tables were ArticlesT and KeyWordT
Created a query with both tables and added the article row from ArticlesT and added the keyword row from KeyWordT
Wrote an expression Search: InStr([ArticlesT].[Article],[KeyWordsT].[keyword])

As mentioned, not pretty

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 12:34:14 AM. PLT: 1s