Left Function

[Gootz11]

Hello,
I want to run a query that looks at the colum to the left (slot #) and if the slot number ends in a 1,2,3,4,5,6,7,8 or 9 it will assign a number to that record. and if the slot number ends in "0" it will assign another number.
example Slot Number 122522 would = 14 and
Slot Number 122520 would = 21

Please Help
Thanks In Advance

Gootz

 

[ColinEssex]

Hi

In your first example the sum of the first string of numbers = 14
so presumably you want the total of all the numbers added together -

but where do you get 21 from, is that random? - am I being thick?

Col

 

[simongallop]

To look at the last digit then you need the formula right([SlotNumberFieldName],1) This will show the last number for you to then assign whatever it is that you want.

HTH