Get rid of Exact Search

[N1ck9141]

My problem - i have a huge data base with 1000's of items and i have created a query with the [enter name] as critier but of course i have to enter the name perfectly which is hard to remeber all those names...

is there any way i can create a query still with an enter name box however when i type "be" for example, i will get all the results in name colum contain "be" such as ben betty bev bert etc....

need help asap please

 

[maxmangion]

try

Like "*" & [enter name] & "*"

 

[DCrake]

Simple Software Solutions

There are two approaches to this, you can either type in a known string into a parameter and have the criteria

Like [Enter Name] & "*"

Or

In your Parameter type in "Be*" and have your criteria

Like [Enter Name]

When you are prompted to enter the persons name you can employ wildcard characters in the prompt, so for example "Sm?th*" would find

Smith
Smyth
Smythe


CodeMaster:

 

[N1ck9141]

thanks

thank you all for the quick reply i had been trying things like this and didnt have the syntax right the best result i got was from this line

Like "*" & [enter name] & "*"

however i tried all the surgestions and all gave results that will be handy for other things thank you

 

[maxmangion]

you're welcome

 

[N1ck9141]

secondly problem

ok similar thing now ive found all the names etc i want is there an easy way to replace a lot of data in a query for example..

at the moment if i search last name doe for example i get
john doe
jane doe

etc but say they change there name to eod

can i do a search which will select what ever i enter eg "doe" and then replace it with waht i type next "eod"

this one isnt as important cause im jst using the find and replace tool built into access however it would be handy to do it through a query so others on my network dnt have to be taught thanks you again

 

[namliam]

You can use update queries to mass update records if you want....

 

[maxmangion]

you can try the update query.

 

[N1ck9141]

how?

update query sounds like a clever idea but when i go query tab and do new i dnt get update query as an option any more advise please???

 

[maxmangion]

Double Click on query in design view, once you're there from the Query Menu at the top select Update Query.

 

[N1ck9141]

thanks but ive never used that before ive open design view added the table selected update query now what else do i need to do so it will give me two boxes so to speak one to select orignal and one to change to ???