Access 97

[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 )

 

[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 )

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

John W. Vinson[MVP]