| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
No of Records returned by a Query
Hi All,
How I can count the number of records returned by an MS Query from Access DB? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
No of Records returned by a Query
you can use the COUNT() or COUNTA() functions on any of your querytable
columns, as long as it is one you know is never null (blank); for example, if I had a date in column C that ALWAYS had a value, I would use =COUNT($C:$C)-1. The purpose of the -1 is to subtract the column header, assuming you chose to display them. "Soniya" wrote: Hi All, How I can count the number of records returned by an MS Query from Access DB? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort the information returned from a query? | Excel Discussion (Misc queries) | |||
| Query returned more data than will fit on a worksheet | Excel Discussion (Misc queries) | |||
| Using Excel's Auto Filter, how can I show # of records returned? | Excel Worksheet Functions | |||
| This query returned no data | Excel Worksheet Functions | |||
| The Web query returned no data | Excel Programming | |||
![Soniya[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
