link two data fields one is subset of another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have two data fields. Field1 is 5 character length and Field 2 is 3. I
need a query in which Field2= first 3 character of Field1. How do I do that?
Thank you for your help.
 
One method is to use like and wildcards in your criteria.

Field: Field1
Criteria: Like Field2 & "*"
 

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

Using If or Iif to determine a value 3
access form 1
DSum update query with multiple fields 0
Scaling results in data truncation 2
Creating a query out of another query 1
Group By, Max and Min 2
Format text to add character 5
Tabbed Pages Not Refreshing 1

Back
Top