Equivalent of RunningSum Property

[unleaded14]

Hi,

Good day to all. I'm an newbie in visual basic. I just want to know what is the equivalent of MSAccess Report's(Textbo x) RunningSum property to VB6's Datareport.
You see I'm trying to count the rows displayed on the the detail section of the VB6 datareport and can't seem to find a way to do it.
I have tried it before in Ms Access and I used the runningsum property. But in VB6 datareport, the is no runningsum property.
It there another way to go around this problem? Please help.

thanks in advance

[Hemant Pathak]

Hi..........


you can make a new SQL field like your other field and write below Sql string

Select Count(*) as TotalRecords from TableName

and drag into the ur report.

[unleaded14]

Hi..........


you can make a new SQL field like your other field and write below Sql string

Select Count(*) as TotalRecords from TableName

and drag into the ur report.

Thanks for the suggestion. I have thought of this before. But you see I just want to count/limit the munber of records displayed on the detail section of the data report. Here's the scenario. I have a datareport and I wanted to display only 18 records per page. So the 18 records are counted and the number is displayed beside them. Some sore of like this found on one page.

1 Alex
2 John
3 James
.
.
.
.
.
18 Robert