Run Query

  • Thread starter Thread starter Chantal
  • Start date Start date
C

Chantal

Hello:

In my database, I have entered records such as:
BACS 100
BACS 200

ENG 101
ENG 102
ENG 104

and so on. I want to run a query just for all of
the "ENG" record. How do I set the criteria for this.
When I enter just "ENG", I get nothing.

Also, where can I get a list of codes to enter my
criterias.

Thanks - Elise
 
Do you mean you want to compare the first part of the
string?

WHERE fieldname LIKE 'ENG*'

(I think you use "*" in Access. I'm used to MS-SQL)
 
Back
Top