Hi, I have a webtable with rows and cols. One of the cols is ID and when a temp id is allocated to a record the value in the col ID starts with T else it starts with a number. Now i need to get the count of all records(rows) which start with T. how can i achieve this. Please help.
Re: Counting Rows with a particular value in WebTable
Well, you could get the rowcount, then step through each row using a For..Next loop and get the value in the Col ID column of each row and check it, maybe using a Left() function to check the left character to see if it is a T and incrementing a counter each time a T is found.
But I think tht might be a little slow.
It might be better if you could just get all items into a variable, split that into an array, then check the correct element of the array to see if it contains a value that starts with a T. That would take a bit more coding but probably would run faster.
"The last 10% of any software project will take 90% of the budgeted time. The first 90% will take the other 90%"