How does it work

  • Thread starter Thread starter avanel
  • Start date Start date
A

avanel

Hey

Please I need some help: Say that i want to search a persons address iin my
database.
and i type in the name and puff i want the address to show up on the screen.
How do I do this Can you help me please?
 
create a query

select *
from [thetable]
where [personsnamefield] like "*" & [enter a person name] & "*"

and save this as something then run it

where thetable is the name of your table and the personsnamefield is
the name of the field that stores the persons name
this will also search by wild cards ie if you seach for jo it will
give you

jo
john
billy-bob-jo
etc

if you want exact matches

use

select *
from [thetable]
where [personsnamefield] = [enter a person name]

to add this query create a new query in design view
click cancel on the pop up window
click on view
then click on sql view
then paste the above in there with the relevant changes

hope this helps

Regards
Kelvan
 
Back
Top