worker bee (1/11/2012)
Try this to start, I found this on another web site. I googled count figures in sql table.http://www.w3schools.com/sql/sql_func_round.asp
SELECT DataKey, ROUND(DataKey,0) as DataKey FROM Tablename
I feel you are not understanding my requirements. I know how to run counts, I just want the best way to run the ones I am after.
the round command does not relate to my question the round command is to round a numeric field to the specified number of decimal places...