0

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

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by AUGXIS
0

Hi,

Connection Object is not mentioned...:

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

Regards
Veena

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.