Good Morning All,
I'm trying to figure out how someone calculated a field in a query I am working with and I am confused. Here is the calculation:
SCCAmt: Sum(IIf(SCCPremium([SCC],[Bacteria])>0,SCCPremium([SCC],[Bacteria])*[sumOfLbs]*0.01))
I'm especially not understanding this part: SCCPremium([SCC],[Bacteria]). Are they trying to find the total value of these two fields and assign it to a new field SCCPremium?
I believe this code was written in a very old Access version, but I can't find this online anywhere. Any help would be greatly appreciated.
Thank you in advance!
I'm trying to figure out how someone calculated a field in a query I am working with and I am confused. Here is the calculation:
SCCAmt: Sum(IIf(SCCPremium([SCC],[Bacteria])>0,SCCPremium([SCC],[Bacteria])*[sumOfLbs]*0.01))
I'm especially not understanding this part: SCCPremium([SCC],[Bacteria]). Are they trying to find the total value of these two fields and assign it to a new field SCCPremium?
I believe this code was written in a very old Access version, but I can't find this online anywhere. Any help would be greatly appreciated.
Thank you in advance!