Fun with percentages (1 Viewer)

[Spruk_77]

Hey all,

I need more help, yet again. Here is my table set up

Table Name: Personnalinfo
SSN
Name
PCSETS
SEADABrief

I have the following quieries:

Query1 returns the all people who have a NO in PCSETS

Query2 returns all people who are NO in PCSETS and have a valid date in SEADABrief

I would like to have a count of the total number of people in Query 1.
I would also like a count of the total number of people in Query 2
I would like to divide the number of people in Query 2 by the number of people in Query 1 to find a percentage.

If I have to do this in a query that is fine, but I would like to have this in a text box at the bottom of a report

Thanks for any help

 

[AnnaFoot]

You could set up a text box on your report with the following record source:

=dcount("[pcsets]","query2")/dcount("[pcsets]","query1")

set the format of the text box to percent and that should work.

Basically you are counting the number of records returned in the second query, and dividing it by the number of records returned in the first query.

Anna

 

[Spruk_77]

Thanks,

It works perfectly.