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

[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.

 

[fredg]

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.

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