Comma positioning

[dastr]

Hi all,

I have the following issue; I have the below size sequence:

44,46,48,50,52,54,56,58,60,62,66

and I would like to pick up in a query only 44 and 46.

For 44 I have

CommaPos: InStr([Sizes],",")

Num:IIf(InStr([Sizes],",")=0 Or IsNull([Sizes]),[Sizes],Left([Sizes],InStr([Sizes],",")-1))

But I cannot figure out how to cut off 46. Any help will be appreciated?

The idea is to have in a separate column 44 and in another one - 26.

thanks

 

[pr2-eugin]

Hi dastr, The example is okay.. But can hardly understand what you are trying to do. Could you rephrase your problem again?