Count Records

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

Hello,

I would like to count the number of records returned in a MS Access query.
All the query does is list the number of appointments made for the last 7
days. I want Excel to count the number of records that query returns.

Is this possible?
 
Let's say the query puts data in column A, wh8ich is otherwise empty. Then
use:

=COUNTA(A:A)
 
Back
Top