424,967 Members | 1,740 Online Need help? Post your question and get tips & solutions from a community of 424,967 IT Pros & Developers. It's quick & easy.

Access iff statement

 P: 13 Hi, I came across these 2 statements. Can anybody know what does that mean. EARN_LF1: IIf([BW]=0,([TOT_EARN]*0.9),([TOT_EARN]*0.6)) ([LFFBUDMH2: IIf([LFF]=0,0,([LFFBUDMH1])) Thanks Mar 8 '07 #1
3 Replies

 Expert Mod 10K+ P: 12,347 Hi, I came across these 2 statements. Can anybody know what does that mean. EARN_LF1: IIf([BW]=0,([TOT_EARN]*0.9),([TOT_EARN]*0.6)) ([LFFBUDMH2: IIf([LFF]=0,0,([LFFBUDMH1])) Thanks Expand|Select|Wrap|Line Numbers EARN_LF1: IIf([BW]=0,([TOT_EARN]*0.9),([TOT_EARN]*0.6)) This creates a field called EARN_LF1. If BW is equal to 0 then EARN_LF1 will equal 90% of TOT_EARN. If BW is not equal to 0 then EARN_LF1 will equal 60% of TOT_EARN. Expand|Select|Wrap|Line Numbers [LFFBUDMH2: IIf([LFF]=0,0,([LFFBUDMH1])) This creates a field called LFFBUDMH2. If LFF is equal to 0 then LFFBUDMH2 = 0. If LFF is not equal to 0 then LFFBUDMH2 = LFFBUDMH1. Mar 8 '07 #2

 P: 13 Thanks a lot. Mar 9 '07 #3

 Expert Mod 10K+ P: 12,347 Not a problem. Mar 9 '07 #4 