Member Avatar for AUGXIS

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
  • 89 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by AUGXIS

Recommended Answers

All 2 Replies

Member Avatar for QVeen72

Hi,

Connection Object is not mentioned...:

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

Regards
Veena

Member Avatar for AUGXIS

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.