 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2005Percetage in Access - Calculations
-------------------------------------------------------------------------------- I need help. I have several Excel formulas that I need to use in Access. I am no sure just how to do it. What I need to do in Access is find th 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 finis this data base soon -- HalliezPosted from http://www.pcreview.co.uk/ newsgroup acces At least one reply in another NG where you posted the same question. Please don't post to multiple groups. You can send the same message to multiple groups by placing all the group names in the Newsgroups: line separated by semi-colons.  SignatureDuane Hookom MS Access MVP > -------------------------------------------------------------------------------- > [quoted text clipped - 15 lines] > Thanks ahead for your help. I am really in a crunch, need to finish > this data base soon. Thanks, I did not know that I could post that way. I am very sorry, just a little frustrated trying to get this datebase done. Sorry agai -- HalliezPosted from http://www.pcreview.co.uk/ newsgroup acces |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.