Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quickly check for no of records returned

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hi all,
How do I quickly check the # of records returned by a query?
What I am doing right now is Count(<Acc No>) and its taking forever to compute.
Thanks!

John
 
From the Menu Bar - Click on Data->View Data-> then the Definition Tab of the Data Manager Dialog Box and in the bottom right hand panel is the number of records and last refresh date/time and duration.

Clicking on the cube icon also takes you to the Data Manager Dialog Box
 
Hello John,

Try using the dataprovider function NumberOfRows(&quot;X&quot;)
where X is the dataprovider as estblished by BO. Use this at reportlevel in a cell. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top