Computing.Net > Forums > Office Software > Creating a = Query Question=

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Creating a = Query Question=

Reply to Message Icon

Name: koJoTee
Date: April 10, 2004 at 09:50:27 Pacific
OS: Windows XP
CPU/Ram: 3.0 GHZ/1 GB 400mhz Dual
Comment:

I have a hard time creating a query that would return with desired results. I first created a table with all my games. After that I tried to created a query that asks user a question, in criteria I typed [What game are you looking for?] What the problem is that it returns ONLY the FULL names of the games. I would like when I type for ex. "soldier" to show me all the names of game titles that have a word "soldier" within them. Is there a way I can do it without entering for ex. LIKE "*soldier*" , any hel would be apreciated, Thank you in advance!



Sponsored Link
Ads by Google

Response Number 1
Name: bad_brains
Date: April 13, 2004 at 06:49:19 Pacific
Reply:

You've answered your own question. Simply use like exactly as you've entered it.


0

Response Number 2
Name: brizboy
Date: April 13, 2004 at 09:30:37 Pacific
Reply:

Hi

This link should be of help.

http://www.accessdatabasetips.com/queryparameters1.html

Part 2 of this series (link at bottom of the page) discusses searching for substrings in records using wildcards.

Hope this is what you are looking for

Kind regards
brizboy


0

Response Number 3
Name: koJoTee
Date: May 12, 2004 at 18:09:04 Pacific
Reply:

Thx it was a great help Like "*" & [hehe] & "*" Trick did what I wanted! Thx again!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Creating a = Query Question=

Creating a drop down menu www.computing.net/answers/office/creating-a-drop-down-menu/3028.html

Queries in Access 2000 www.computing.net/answers/office/queries-in-access-2000/534.html

A Query for MS ACCESS www.computing.net/answers/office/a-query-for-ms-access/3177.html