nicht angemeldet
Hello,
IIf(InStr(Tabelle1.ArtNr,"-") <>0, Left(Tabelle1.ArtNr,InStr(Tabelle1.ArtNr,"-")-1) AS dummyspalte
also, dein
IIf = CASE WHEN
InStr = INSTR
Left = LEFT
damit solltest du alles haben.
MfG
Rouven
--
-------------------
sh:| fo:} ch:? rl:( br:& n4:{ ie:| mo:} va:) js:| de:] zu:| fl:( ss:) ls:& (SelfCode)
Buy when there's blood running in the street and sell when everyone is pounding at your door, clawing to own your equities -- Wisdom on Wallstreet
-------------------
sh:| fo:} ch:? rl:( br:& n4:{ ie:| mo:} va:) js:| de:] zu:| fl:( ss:) ls:& (SelfCode)
Buy when there's blood running in the street and sell when everyone is pounding at your door, clawing to own your equities -- Wisdom on Wallstreet