Sum() in Active report

[xpcer]

halo friends, i have a problem with my program.
i use a ms access as a database with indonesian format,
i have a student table that contains 3 fields: student_id, student_course, student_score

the score is decimal

if i have a data like this:
student_id student_course student_score
---------------------------------------------------------------
001 Programmig 7,5
001 Algoritma 8,5

note, the student_score using comma.
when i want to show the sum of the student_score using Active Report,
the sum of student_score is 15. can u help me... please

[sashi]

Hi there,

do you need the comma or the comma appears from nowhere and you want to format the value of student_score with decimal? which one?

[xpcer]

Hi there,

do you need the comma or the comma appears from nowhere and you want to format the value of student_score with decimal? which one?

thanks for mr. sashi
i have get the solution,
when i want to add the data, i must to convert it to a single using CSng() function

[sashi]

Hi XPCer,

good luck my fren..