[MSAccessProfessionals] Syntax error

Dear Colleagues,
I got the attached message for b/m function,
thanks to feedback with what mistake I did
Notes: for data types (RecordCode - AccountID - TransactionTypeID) all are string variables 

Public Function TotalDebitTillRecordCode(txtAccountID As Variant, txtRecordCode As Variant) As Double

TotalDebitTillRecordCode = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] like " & txtAccountID & " And Val([RecordCode]) <= " & txtRecordCode & " And [TransactionTypeID] =" & 2)

End Function

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116196) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_