S smichaels1234 Registered User. Local time Today, 12:52 Joined May 12, 2008 Messages 64 Jun 5, 2008 #1 Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2 Or "I",3)
KenHigg Registered User Local time Today, 12:52 Joined Jun 9, 2004 Messages 13,327 Jun 5, 2008 #2 What if [SalesOrdersDivision] does not equal D or I?
S smichaels1234 Registered User. Local time Today, 12:52 Joined May 12, 2008 Messages 64 Jun 5, 2008 #3 Well, then it just goes to both.
A Alc Registered User. Local time Today, 12:52 Joined Mar 23, 2007 Messages 2,421 Jun 5, 2008 #4 smichaels1234 said: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2 Or "I",3) Click to expand... I think this should do it Code: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2, ([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="I",23)) Are 'D' and 'I' the only possibilities? If not, and there's some catch-all value for the rest (say 4), try this Code: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2, ([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="I",3,4))
smichaels1234 said: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2 Or "I",3) Click to expand... I think this should do it Code: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2, ([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="I",23)) Are 'D' and 'I' the only possibilities? If not, and there's some catch-all value for the rest (say 4), try this Code: Division : IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="D",2, ([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]="I",3,4))
A Alc Registered User. Local time Today, 12:52 Joined Mar 23, 2007 Messages 2,421 Jun 5, 2008 #5 I just read your reply to Ken's post. When you say both, do you mean 23, 2+3, or what? If it's the former, replace the 4 in the second one I wrote with 23.
I just read your reply to Ken's post. When you say both, do you mean 23, 2+3, or what? If it's the former, replace the 4 in the second one I wrote with 23.
S smichaels1234 Registered User. Local time Today, 12:52 Joined May 12, 2008 Messages 64 Jun 5, 2008 #6 What you gave me worked. I am all set. I was looking for either an I or a D if not give me both. It helped me. I needed to do a little cleaning up but it definitely pointed me in the right direction. Thank you.
What you gave me worked. I am all set. I was looking for either an I or a D if not give me both. It helped me. I needed to do a little cleaning up but it definitely pointed me in the right direction. Thank you.
S smichaels1234 Registered User. Local time Today, 12:52 Joined May 12, 2008 Messages 64 Jun 5, 2008 #7 This is what I was trying to do, I will just post it: IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]=2,"D",IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]=3,"I",[division]))
This is what I was trying to do, I will just post it: IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]=2,"D",IIf([Forms]![frm-Shippable Items w/Detail]![SalesOrdersDivision]=3,"I",[division]))
A Alc Registered User. Local time Today, 12:52 Joined Mar 23, 2007 Messages 2,421 Jun 6, 2008 #8 Glad it helped.