ExcelBanter - Count Records

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count Records (https://www.excelbanter.com/excel-worksheet-functions/177174-count-records.html)

Rod

Count Records

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?

Gary''s Student

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?

All times are GMT +1. The time now is 09:26 AM.