hi guys,

i was trying to sum up all the balances of clients to know which of them has reach their credit limit but my codes are not working. It shows an error and highlights on this code

rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & shippercode & "'"

thanks in advance

Hi,

Connection Object is not mentioned...:

rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & shippercode & "'" ,Conn

Regards
Veena

my bad. thanks for the help. just too stupid of me not to see that part.