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."
 

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

Formula help 7
Excel Move or Copy Stopped Working? 0
Combo box to fill text boxes.. 3
Populate a text box after update 4
DLookup AutoFill Help 1
References Help 1
Access Microsoft access database(creating a search engine form) 0
Access Form - Lock Fields from Editing 0

Back
Top