Left Function?

  • Thread starter Thread starter dataH
  • Start date Start date
D

dataH

Hello

(Access 2007)

I have a field in a table containing 8 characters. I would like to copy the
left four characters only to a field in a new table. I've tried the left
function in the criteria row as follows but i get a 0 rows transfered.

left([fieldname], 4)

Any help?


Thanks
 
Don't put it in the criteria. Put it in an expression on the field line.
Something like
"LeftPartOfName: Left([FieldName],4)" without the quotes. Make sure you
have a space after the colon.
The data will be returned under a psuedo field name of "LeftPartOfName" and
will contain the data you want.

Regards
Kevin
 
Works great

Thanks



KC-Mass said:
Don't put it in the criteria. Put it in an expression on the field line.
Something like
"LeftPartOfName: Left([FieldName],4)" without the quotes. Make sure you
have a space after the colon.
The data will be returned under a psuedo field name of "LeftPartOfName"
and will contain the data you want.

Regards
Kevin


dataH said:
Hello

(Access 2007)

I have a field in a table containing 8 characters. I would like to copy
the left four characters only to a field in a new table. I've tried the
left function in the criteria row as follows but i get a 0 rows
transfered.

left([fieldname], 4)

Any help?


Thanks
Click to expand...
Click to expand...
 
Back
Top