Removing last letter of a string

[billcub]

In Access 97 can I remove the last letter of a Field [field1] using a query ?

 

[GingerR]

yes.
in a blank column in the query put this:

NewText: Left([Field1],Len([Field1])-1)

this determines the length of your field (LEN), and subtracts 1 from that length. then takes the left part of the field that many characters (LEFT).

g

 

[MichaelRed]

Hmmmmmmmmmmmmmmmmmmmmmm,

Only if " ... last letter ... " == Any Character AND the field is in fact a string field.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over