i want to use the sum function on a filed on a table in access2000. i am
using module. so if i type

x=("select sum[filed_name] as [any_var] from mytable".

Debug.Print x
Debug.Print any_var
i get the following answer in the Immediate table like an echo

select sum[field_name] as {any_var] from mytable

so i have no clue how i use the sum function in sql-statement in module
any advise will be appreciated