advice on using table in vb.net

[Steven Low]

Hi guys

What I like to do is in vb.net I have loaded a table from access in vb.net

and what I like to do is in attendance colume I would have ////

and in total attendance colume I would have the / as a number 3

soo what its doing is counting the slases from the attendance table and counting them as numbers in total attendance.

How would I do this using access in vb.net

I thought of doing this in access but its doesnt like the word Len("replace")

How else would I go about this guyss

 

[jmcilhinney]

My opinion is that that is a very bad idea. If you want to store a number then store a number in the first place. If it's within your control then redesign your database and don't store that string of slashes at all.