General information
Category:
Coding, syntax & commands
Title:
Need a select query to determine whats the max no of points
I have a table tasks: and the field name is Taskcode:
In the taskcode: i can enter .01 or .01.102 or .01.102.103 like that
So i have to find searching all rows in that table for that field(Taskcode) to see where maximum points are.
each point represents one level:
if it is .01 only it is 1 only one level
if it is .01.12.14 then it is 3 has three levels, i see there are three points in it.
ones i establish the maximum levels then i can do the other stuff.
Can you please tell me, is it possible to get that info.
Table name is Tasks and field name is Taskcode.
Thank you very much for the information.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only