Access 97

B

Bruce

I have a Field on a Form which contains numbers Null through 1 to 9. I need
a count of only the number 3. How can this be done the Field name is Action.


Best Wishes
Bruce
( Illegitimi non carborundum est )
 
J

John Vinson

I have a Field on a Form which contains numbers Null through 1 to 9. I need
a count of only the number 3. How can this be done the Field name is Action.


Best Wishes
Bruce
( Illegitimi non carborundum est )
Click to expand...

SELECT Count(*)
FROM tablename
WHERE [Action] = 3;

John W. Vinson[MVP]
 
Top