Access Percentage Calculation--Help

H

Halliez

Joined
Jul 3, 2005
Messages
2
Reaction score
0
--------------------------------------------------------------------------------

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percetage in Access - Calculations 0
Need help with formula!!!! 2
Access Query 3
Payment calculation 1
Formula Cell color limitation 7
Repeat Cell Based on the Value-Excel 2003 3
Summing a range of cells based on criteria in another range 2
IF formula returns FALSE 1

Back
Top