Criteria for a query

  • Thread starter Thread starter Big Tony
  • Start date Start date
B

Big Tony

In my query, I want to be able to select and analyze a
set where the first two letters in the primary key are
BK. Is there a way I can specify that in the query
criteria?.
 
Try typing:

Like "BK*"

in the criteria row of the primary key field. I think
that will get you what you are looking for.

HTH, Ted Allen
 

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

Access Dcount (multiple criteria) 3
Use In() Expression as Query criteria with guts from Function 1
Listing all fields in a query 0
criteria on form 1
Criteria in a Querie 8
How to do Multiple update in one query 3
All-Record criteria in a query...hmmm 4
Query twice with the same criteria ==> 6

Back
Top