Thread: Count Records
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Count Records

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

=COUNTA(A:A)
--
Gary''s Student - gsnu200769


"Rod" wrote:

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?