dcount

's Computer Specifications

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

's Computer Specifications

On Sat, 29 May 2010 11:02:01 -0700, Tim
<(E-Mail Removed)> 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")

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dcount	Evi	Microsoft Access Form Coding	2	13th Mar 2008 03:50 PM
Dcount	Gaetanm via AccessMonster.com	Microsoft Access Forms	8	22nd Feb 2008 08:26 PM
DCount	Chris	Microsoft Access Getting Started	6	5th Sep 2005 05:45 PM
How can i use DCOUNT without getting error when DCOUNT returns null	vasal	Microsoft Access Form Coding	1	15th Dec 2004 09:48 AM
DCOUNT or not DCOUNT, that is the question	Chris M.	Microsoft Access Queries	2	15th Jul 2004 04:22 PM