dcount

[Tim]

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

 

[Tom van Stiphout]

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

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

-Tom.
Microsoft Access MVP