Child ID Access

I have a Access database and want to display a percentage on a report. Specifically I need to perform the following calculation.

100*(1-(<# of entries in Query 1>/<# of entries in Query 2))

Since I don’t have a lot of experience with Access I don’t know how to use the COUNT function for this application (I think COUNT would be the function to use). If you need further information on the queries:

Query 1 has fields:
-Employee Number
-Surname
-Given Name

Query 2 has fields:
-Key (Autonumber)
-Employee Number
-Surname
-Given Name

Thanks in advance for your help.

I think the function you want is DCOUNT.

DCount("[OrderID]", "Orders", "[ShipRegion] = ‘CA’")

That example counts number of orders in the orders table where the shipping region is CA.

This entry was posted on Sunday, February 21st, 2010 at 11:36 am and is filed under access count. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.