how do I to build a simple search expression using a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to run a query allowing users to find general data from specific
fields but I don't know the exprssions to use.. For example: I have a
collection of product information sent by companies that I have put o to a
simple database. The database comprises 'company; product; classification'
information. I want to be able to search my database using a query, to see if
any any literature apertaining to a given company is available from my
collection. Therefore I want o find 'General Motors' or companies who's
names begin with the letter G. I therefore want to run a searhc such as G
or general or general motors. I want to do this avoiding the MS access
search tool, which I find difficult for users to use.
 
I want to run a query allowing users to find general data from specific
fields but I don't know the exprssions to use.. For example: I have a
collection of product information sent by companies that I have put o to a
simple database. The database comprises 'company; product; classification'
information. I want to be able to search my database using a query, to see if
any any literature apertaining to a given company is available from my
collection. Therefore I want o find 'General Motors' or companies who's
names begin with the letter G. I therefore want to run a searhc such as G
or general or general motors. I want to do this avoiding the MS access
search tool, which I find difficult for users to use.
Click to expand...

As criteria on the Company field in the query, write:
Like [Enter Company Name] & "*"
 
Back
Top