How do I use the wildcard query to find words like "the" in the ta

T

Twiggy

I need help with this....ive created a Stock Register Table in Access 07
containing CD Titles, Artists, price of the CD etc but I need to find out how
many CDS are by Artists starting with "The"....
I also got to use the wildcard query to find the words and Im not to sure on
how to as I'm new to using Access.....Please help thanks
 
T

tina

I also got to use the wildcard query to find the words

sounds like a classroom assignment, Twiggy. most people here won't give you
solutions to classwork, because part of the learning process is learning how
to find the solutions you need. i can suggest that you read up on wildcard
characters in Access Help, and/or refer to whatever Access textbook you're
using. i'd think there would be a section on building queries and setting
criteria.

hth
 
K

KC-Mass

Look at the "Like" function in Access Help. In the simple example you gave
you would set the Criteria in the title field to Like("The*")

Regards

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcard parameter query not working 5
Query wildcard symbols 4
How do I used wildcard characters in Query by Form? 1
Wildcard in query 10
Wildcard sub query 1
Wildcard problem in joined query 2
How to query 2 tables and then perform a wildcard search using a 3 1
find and replace using wildcard characters 2

Top