Calculating a Total From A MDB Table

[mx3com]

How would I go about Calculating the number of records which have a Check box checked in a table using CF?

Basically what I am after is a total of the completed entries in the Table.

For Example:
50 Records listed in the table, 30 of them have a check box field checked to say they are completed. I need to display the number 30 as a result, which I should be able to change into a percenetage (60%) easily enough. Possibly later on even taking these results as far as showing a graph or chart for percent completed?

Any advice is greatly appreciated. Thanks in advance.

Jeff Aycan - mx-3@home.com - Webmaster, MX-3.com

 

[GunJack]

Hi Jeff,

Will this work for you? You'll just need to substitute your table and field names.

<cfquery name=&quot;q1&quot; datasource=&quot;myDatasource&quot;>
select from table1 where checkField = 1
</cfquery>

<cfoutput>#q1.recordcount#</cfoutput> records are checked.

GJ

 

[mx3com]

I should have known that one! (I've used the record count statement before.)
It worked, Thanks!

Jeff Aycan - mx-3@home.com - Webmaster, MX-3.com