Extracting characters from a field with Access 2003

[Abay]

Hello ... I would like to copy the contents of a field called isbn, minus
its last four characters into another field. I thought the following would
work as an expression in a query,but get an error message saying "the
expression you entered has a function containing the wrong number of
arguments"

Left(Len([isbn])-4)

Any help on this would be most appreciated.

Thank you
Abay

 

[John W. Vinson]

Hello ... I would like to copy the contents of a field called isbn, minus
its last four characters into another field. I thought the following would
work as an expression in a query,but get an error message saying "the
expression you entered has a function containing the wrong number of
arguments"

Left(Len([isbn])-4)

The Left() function takes two arguments - a string and a length. You're only
giving it the length! Try

Left([isbn], Len([isbn])-4)

 

[Abay]

Many thanks John, excuse my ignorance & of course that worked!

Abay

Hello ... I would like to copy the contents of a field called isbn, minus
its last four characters into another field. I thought the following
would
work as an expression in a query,but get an error message saying "the
expression you entered has a function containing the wrong number of
arguments"

Left(Len([isbn])-4)

The Left() function takes two arguments - a string and a length. You're
only
giving it the length! Try

Left([isbn], Len([isbn])-4)

 

[John W. Vinson]

Many thanks John, excuse my ignorance & of course that worked!

Glad it worked. Just for future reference, you can select the name of a
function and press F1 to quickly jump to the help topic on that function; this
can help explain puzzling error messages like this.