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,
 
Back
Top