Avatar of gigifarrow
gigifarrow
 asked on

Using DCount to count certain fields in a table

I have a tabel that has a field called, DIV. In those fields are name of companies.
I need the total of certain companies that are in the DIV field. I am using an unbound field to put this information in.  


So what Im trying to say is look in this table under div and find 190-HBCT and count how many times it appears. Then divide that number by 20 to get the total percentage completed by that unit.

=DCount("DIV","tblMODHistory","190-HBCT=-1")/20
=DCount("DIV","tblMODHistory","1CAV=-1")/20
Microsoft Access

Avatar of undefined
Last Comment
IrogSinta

8/22/2022 - Mon
IrogSinta

Are you saying that your DIV field has data such as 190-HCBT and 1CAV?  If so then these should work:

=DCount("*","tblMODHistory","190-HBCT")/20
=DCount("*","tblMODHistory","1CAV")/20
trbaze

Is '190-HBCT' a field?  if so, try enclosing it and also 'DIV' in brackets.
=DCount("[DIV]","tblMODHistory","[190-HBCT]=-1")/20
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
IrogSinta

Oops, as mbizup's answer shows, I forgot part of the argument in my response.  Looks like either his answer or trbaze's would work for you depending on how you have your fields set up.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck