Help figuring out formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a question and was woundering if it is possible! I have a form
with a few tabs and on each tab there is a combo box where you select eather
Outstanding,Excedes Requirements, Needs Improvement and Unsatisfactory. and
on the last tab I have a few text boxes that show what was selected for that
combo box using =[NameofComboBox] in the text box's Control source. I was
woundering if there was a query or something I could use to calculate the
average or most used word and have it generat in a text box. Is this
possible? If so how would I do it... thnaks!
 
Chad,
Sounds like what you would want is the percentage of each value over all
records.
Given 100 total records, and 25 of them are Status "Outstanding" then...
(use your own object names)
=DCount("[Status]","tblYourTable","Status = 'Outstanding'") /
DCount("*","tblCustomers")

Would yield
25 / 100 = .25
(or 25% with percent formatting)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top