query help

[Steven Low]

Hi guys
Im creatingh a query in my access which allows

// symbols to be counted as numbers in the totalattendence

i got it to count the symbols but i only want it to count /// as number soo it counts /x/ anything but i only want it to count /

heres what i have done in sql view in access

SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len([Attendence]) AS totalattendence
FROM student;

 

[lingsn]

I think is something like

SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len(Replace([Attendence],"*","")) AS totalattendence
FROM student;

 

[Steven Low]

Hi

The problem is I want to put the query onto vb.net datagrid.

SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len(Replace([Attendence],"*","")) AS totalattendence
FROM student;

but with the above query i cant for some reason. which i really want in the datagrid in vb

with this query below below I can easily be showed on the datagrid.
SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len([Attendence]) AS totalattendence
FROM student;

Why am I getting this and is it possible to be put on the datagrid in vb.net?

 

[lingsn]

Forgot to change the * to x

SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len(Replace([Attendence],"x","")) AS totalattendence

 

[Steven Low]

I still get the problem of putting this query table in vb.net as a data grid

why is this?

 

[Steven Low]

Hi Lingsn

I found out that I cant use the word "replace" that is why i cant use it in vb.net

Len(Replace([Attendence],"x","")) AS totalattendence

is there anything else I can use apart from replace which would allow the query 2 to be used in vb.net datagrid

 

[lingsn]

How about this in VB.NET?

[B][COLOR=#0000ff]Len(Replace([Attendence],"""x""","""""")) AS totalattendence[/COLOR][/B]