By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,967 Members | 1,740 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
3 Replies


Rabbit
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
  1. 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
  1. [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
ssq
Thanks a lot.
Mar 9 '07 #3

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

Post your reply

Sign in to post your reply or Sign up for a free account.