dcount
in [General]
|
From: Tim on 29 May 2010 14:02 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") -- ts
From: Tom van Stiphout on 29 May 2010 21:40
On Sat, 29 May 2010 11:02:01 -0700, Tim <Tim(a)discussions.microsoft.com> 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") |