| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Records | Excel Worksheet Functions | |||
| Count certain records between dates | Excel Discussion (Misc queries) | |||
| count of different type records | Excel Worksheet Functions | |||
| Count Records Between A-K and L-Z | Excel Worksheet Functions | |||
| count the no.of records between two dates | Excel Worksheet Functions | |||
Linear Mode
