Link to home
Start Free TrialLog in
Avatar of 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.

Avatar of IrogSinta
Flag of United States of America image

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

Avatar of trbaze

Is '190-HBCT' a field?  if so, try enclosing it and also 'DIV' in brackets.
Avatar of mbizup
Flag of Kazakhstan image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.