converting nvarchar value to a column of data type int ? [Resolved]

If my [Customer Total] field is '530' the folllowing statement works fine:

VB Code:

rs.Open "Select SUM (Cast([Customer Total] as Integer)) as TOTAL From Paid WHERE Customer = '" & strText & "'", cn

but if the [Customer Total] is '530.68' i get the following error:
[Syntax error converting the nvarchar value '530.68' to a column of data type int.]

Any ideas ? :confused:

Changed it to this:

VB Code:

rs.Open "Select SUM (Cast([Customer Total] as Money)) as TOTAL From Paid WHERE Customer = '" & strText & "'", cn

It works. :p