build an expression in Access query 2003

  • Thread starter Thread starter loucherry
  • Start date Start date
L

loucherry

What expression could I put together to use in an update query that
would
return a string that ends in a space. The target string would be the
first
string appearing in the field. exmp: [Name] Louis W. Cherry. Target
string
is Louis. I wish to put it into [First Name] field.
Lou
 
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

Use In() Expression as Query criteria with guts from Function 1
extract 3 numbers from a string 0
Undefined function 'concatenate' in expression 0
use expression as field name in query 2
Simple Query Expression 4
Access IIF and Instr function 1
Please Help Build an expression 1
use an expression as a field 3

Back
Top