Create a Query

  • Thread starter Thread starter Robb
  • Start date Start date
R

Robb

I would like to find out how to create a query that will
pull the first four charecters regardless of what they
are, or if there is another way to do this any help would
be appreciated.
 
You can use the following expression in the Field: row of a query:

Left([MyField], 4)


hth,
 
You must log in or register to reply here.

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

Query design help 6
Can't create a report from my query in Access 1
Linking Subforms in a Form 10
Date AND Time query 4
Counting multiple memberships 1
Access Print Files from Query Results 0
Forms used to run query 6
Run 2nd query using results from 1st query 0

Back
Top