Access Database

A

ak

i have created database in to access 2003 and now i am trying to design it
and view it so i dont see any data in background.. in other words is there
anyway i can just have a search by line appear in the database where i can
just enter something im looking for and it will search thru the data?? p
 
O

Ofer

I'm not sure that his what you are looking for, but you can search on a
specific field in a table using a query

Select TableName.* From tableName Where FieldName Like "*" & [Please enter a
string to search on] & "*"

This query will search the specific field, with the string you entered.
If you want to search two fields with the same string, you can use that

Select TableName.* From tableName Where FieldName Like "*" & [Please enter a
string to search on] & "*" Or FieldName2 Like "*" & [Please enter a string
to search on] & "*"
 
Top