Ignore last two digits in formula

[anstasija]

Hi Everyone,

I am fighting for about an hour now to find out how to manage it that Access will only consider the 7th and 8th digit of the item number BB33-0KK and not duplicate the 5th and 6th digit of the remaining items.

Here is the item list:



Item number
BB22-1
BB22-5
BB33-0KK
CC00-2

My query has the following formula:
A7-8: Right(Left([price download].[item],8),2)
But in the data sheet view in column A7-8 it is using the 5th and 6th digit for the remaining part numbers instead of ignoring those or using "0", please see below:
A7-8
-1
-5
KK
-2
Hope you can understand my description. I appreciate your help.
Thank you.

[LillMcGill]

A7-8: IIf(Len([item])=8,Right([item],2),0)

[weekend00]

If you only want the 7th and 8th dight: mid(([price download].[item],8,2)

[anstasija]

If you only want the 7th and 8th dight: mid(([price download].[item],8,2)

Thank you for your advice. I have tried it and it returned suprisingly only the last digit (the last K) of the part number with the "KK" addition. I need both of them there.

The remaining part numbers were blank, which is already a win.

[pbaldy]

Actually not surprising. It's probably a typo on weekend's part; if you want the 7th and 8th you'd have to start at the 7th:

mid(([price download].[item],7,2)

[anstasija]

Could think about it myself....
Many thanks. It works very good now!

[pbaldy]

Happy to help, and welcome to the site!