Counting the Number of Decimals in a query field

[Mick99]

Hi All, Just wondering if someone can help with the issue of being able to count the number of decimal points within a field. I can count the number of Chars with the use of the Len function but I am unable to count just the decimals. To give a clear picture of what I am trying to acheive, I am needing to use the decimal points as the key in defining the level of the item number as I can not rely on a char lenght alone. My table = tbl itemdata and the field = itmenumber. Any help would be greatly appreciated.



1 decimal point = "MAIN" 2 decimal points = "SUBITEM" and 3 decimal points = "SUBSUBITEM"

1.0 = MAIN
1.1 = SUBITEM
1.1.1 = SUBSUBITEM


Cheers Mick

[pbaldy]

Try

Len(Field) - Len(Replace(Field, ".",""))

[Mick99]

Try

Len(Field) - Len(Replace(Field, ".",""))

Brilliant thank you so much it works a treat.

[pbaldy]

Happy to help!