How to select characters in a field?

  • Thread starter Thread starter Steel Banana
  • Start date Start date
S

Steel Banana

I need to create criteria in a query. It must select records where the first
3 characters in the field are the same as 3 characters in a text box on some
form.

I'm sure this is an easy one. I've done this before...somewhere...but I
can't recall how to do it!
 
Try

Field: SomeField
Criteria: Like Left([Forms]![Name of your Form]![Name of Control],3) & "*"

SELECT ...
FROM ...
WHERE [SomeField] Like Left([Forms]![Name of Form]![Name of Control],3) & "*"


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Number of characters in a field... 1
Special characters 3
Filtering Data On Entry 8
Finding records with a "/" character in a field 2
junk characters in query result 8
Re: Pass field value selected in Combo Box to SQL Query 1
Use first 3 characters in query 4

Back
Top