formula help

[Lee-Anne Waters via AccessMonster.com]

hi,

i need help with a formula please.

i have a list of user names in my table, for example

bills
henryp
lee-annew

what i want to be able to do is drop the last character on each user name
so only the name is given, for example

bill
henry
lee-anne

any ideas much appreciated
thanks
lee-anne

 

[Nikos Yannacopoulos]

Lee-Anne,

Assuming the table field is Called UserName, what you need is a formula
Like:

=Left([UserName], Len([UserName]) - 1)

HTH,
Nikos

 

[Lee-Anne Waters via AccessMonster.com]

you're a legend..

many thanks

 

[Nikos Yannacopoulos]

Welcome! No legend here, just happened to be there earlier.