Left Function?

[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

 

[KC-Mass]

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]

Works great

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

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