need guidance on microsoft access functions

[yurigurlie207]

i'm using microsoft access to store a list of data. i'm really new at this so i know that i'm probably not using the correct terms to describe what it is i'm trying to do. but here goes:

so far i've loaded the data i need. i only have one table. and there are three attributes: tag, year and title. i want to be able to search through this list of data by tag, year and keywords in the title. so far searching for tag and year is no problem since it's just one single value. but i'm having trouble figure out how to search by keywords in the title which is currently a string of words separated by spaces.

is there a search that's easy to do that can look at each word in a title and if it finds that word in the title, it'll select it and output it?

do i have to break the title down myself? (i can't really do that since there's over 10,000 titles)

i'm just kinda lost as to how i should approach this problem. i hope i explained it all right.
your input would be much appreciated!

yyao@andrew.cmu.edu

 

[WayneRyan]

y,

In queries you can do things like this in the Criteria section:

Like "The*" --> All titles that start with The
Like "*End" --> All titles then end with End
Like "*Most*" --> All titles that have Most in them

Like "*" & Forms![SomeForm]![SomeField] & "*" All titles that have the
contents of [SomeField] (from SomeForm) in them.

Experiment with queries.

Wayne

 

[yurigurlie207]

Thank You!

MAN THAT WAS HELPFUL! thank you!!!!!

y,

In queries you can do things like this in the Criteria section:

Like "The*" --> All titles that start with The
Like "*End" --> All titles then end with End
Like "*Most*" --> All titles that have Most in them

Like "*" & Forms![SomeForm]![SomeField] & "*" All titles that have the
contents of [SomeField] (from SomeForm) in them.

Experiment with queries.

Wayne