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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some query help..... 5
Max issue with an Insert Into Select 2
DLookup 1
Filter by criteria 2
Cross Tab Queru question... 2
Choose() function with option group feed 3
Awkward query! 1
Passing multiple criteria to query a table 2

Back
Top