Access 97 to SQL function conversion

[junior6202]

Hi All,

Im recreating a table in SQL server from access 97 and there's this function that I'm trying to convert. The function is Sum(Val(Nz([ACC]))) Can anybody help?

[ranman256]

if ACC is numeric , you dont need the VAL.
You say table, but tables dont use functions. Queries do.
If you are running a query from Access, ON the SQL table , the function would still be:Sum(Nz([ACC]))