Query returns blank

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

Data base is set up ... run queries several times...works
okay. I want to run a query on 3 fields...containing ID,
Customer Name and Number of Employees. I want to limit
the results to those companies that have Bank And Grocery
in their Company name. In the criteria row...I enter in
the Company column "Bank And Grocery", click run and my
result return with the field names only and nothing else
shows up. Can you help me know what I am doing wrong or
need to do. My software is MS Office XP Professional
Ed. I am a student, learning how to use this software
package.

Thanks for your time and help.
 
Gary,

To find records where the Customer Name contains "Bank and Grocery" anywhere
in the name, you need to use the Like operator and wildcards in the Criteria
row, as in the following example:

Like "*Bank and Grocery*"


hth,
 
Back
Top