Solved MID Function (1 Viewer)

[KINGOFCHAOS17]

Hello all. Need some assistance with using MID in query. I've been using the MID function to split out down the data in column 'PartNbr' this works fine for the most part, however is there a way to only invoke the MID function if column 'CAGE' shows ABC12?

If there's a better function to use than MID I'm open to ideas.

 

[NauticalGent]

What exactly are you trying to do?

 

[MajP]

iif([SomeField] = "ABC12", mid([SomeOtherField],x),[SomeOtherField]))
Guess.

 

[KINGOFCHAOS17]

iif([SomeField] = "ABC12", mid([SomeOtherField],x),[SomeOtherField]))
Guess.

Thank you, I modified it slightly and is working perfectly

NSC: IIf([CAGE]="ABC12",Mid([PartNbr],1,4))

 

[MajP]

I do not think what you posted works. As far as I know the iiF needs a True part and False part (required)

IIf Function - Microsoft Support

In Access, if you need to calculate or display a value based on a condition, use the IIf function. The IIf (Immediate If) function is similar to the If function in Excel.

support.microsoft.com

I would think you need a false part
NSC: IIf([CAGE]="ABC12",Mid([PartNbr],1,4),SomeValueIfFalse)