Thread: dcount
View Single Post
  #2  
Old May 30th, 2010, 02:40 AM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default dcount

On Sat, 29 May 2010 11:02:01 -0700, Tim
wrote:

You are very close:
=dcount("[pass]","GED results","[pass]='y'")/dcount("form3]","ged
results")

-Tom.
Microsoft Access MVP


I would like to use the values in dcount to perform another calculation. I
counted two sets of records and would like to divide the two numbers to give
a percent.

For example =dcount("[pass]","GED
results","[pass]='y'")/=dcount("form3]","ged results")