Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement