Access 97

  • Thread starter Thread starter Bruce
  • Start date Start date
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 )
 
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]
 
Back
Top