How to calculate the length of a fields value separated by comma & assign it to other

[haridharmajan]

in Access I have a table called Leaves in which Jan, Feb, Mar....Dec and Jantotal, Febtotal, Martotal.......Dectotal are fields

now lets say field Jan contains some data like " 01,07,21,29,31 " etc which is the total leave taken in month January here the total is 5 now I need to calculate this automatically after entering it in the form and assign this value to Jantotal

how is that possible I tried to convert it to an array and assigned the length of array to Jantotal but its not working properly the variable I used is not changing from record to next record

please provide me a solution

[puppydogbuddy]

try this:

Dim intCount As Integer
 
' - use split function, placing each line into array as an item
JanTotal = Split("Jan",",")
intCount = Ubound(JanTotal)

[missinglinq]

Am I correct in that you simply want a count of the days entered, as you said, 5 for your example? If so a single line will also do it.

MonthTotal = Len([Month]) - Len(Replace([Month], ",", ""))+1

Welcome to Bytes!

Linq ;0)>

[haridharmajan]

Am I correct in that you simply want a count of the days entered, as you said, 5 for your example? If so a single line will also do it.

MonthTotal = Len([Month]) - Len(Replace([Month], ",", ""))+1

Welcome to Bytes!

Linq ;0)>

thanx its working fine