--------------------------------------------------------------------------------
I need help.
I have several Excel formulas that I need to use in Access. I am not sure just how to do it. What I need to do in Access is find the percentage for two or more fields in my data base.
Here are the Excel formuals
=IF(B10=0,"0",(B9+B10/B8)
=IF(B13=0,"0",B13/10)
=IF(B16=0,"0"B16/(B10+B9))
These are seperate formulas for 3 different field in data base.
I hope I am making sence.
Thanks ahead for your help. I am really in a crunch, need to finish this data base soon.
I need help.
I have several Excel formulas that I need to use in Access. I am not sure just how to do it. What I need to do in Access is find the percentage for two or more fields in my data base.
Here are the Excel formuals
=IF(B10=0,"0",(B9+B10/B8)
=IF(B13=0,"0",B13/10)
=IF(B16=0,"0"B16/(B10+B9))
These are seperate formulas for 3 different field in data base.
I hope I am making sence.
Thanks ahead for your help. I am really in a crunch, need to finish this data base soon.