Create a Query

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.
 
C

Cheryl Fischer

You can use the following expression in the Field: row of a query:

Left([MyField], 4)


hth,
 
Top