Count Function

[Purdue15]

What is a function I can write under criteria that will count each value inside that column?

For example [SELECT COUNT( * ) FROM "Weight"]

Thanks

 

[rzw0wr]

SELECT COUNT(Field) AS New FieldName FROM Table;

I think you have to make a new field for each field. I don't think you can use * if there is more than 1 field in the query.

I find this very helpful.

http://www.w3schools.com/sql/default.asp

Dale

 

[CJ_London]

try

dcount("*","Weight")

or

SELECT Count(*) FROM WEIGHT