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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.