I think there are some missing double-quotes before the final ")".
TotalDebit = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] = '" & txtAccountID & "' AND Val([RecordCode]) <= " & VRecordCode & " AND [TransactionTypeID]= 2")
Duane
If as you mentioned all criteria a text data types:
TotalDebit = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] = '" & txtAccountID & "' AND Val([RecordCode]) <= '" & VRecordCode & "' AND [TransactionTypeID]= '2'")
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Paul Baldy <Pbaldy@gmail.com>
Sent: Wednesday, March 9, 2022 11:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Syntax error
Sent: Wednesday, March 9, 2022 11:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Syntax error
You have a lot of unnecessary concatenation in there. Try
TotalDebit = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] = '" & txtAccountID & "' AND Val([RecordCode]) <= " & VRecordCode & " AND [TransactionTypeID]= 2)
If as you mentioned all criteria a text data types:
TotalDebit = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] = '" & txtAccountID & "' AND Val([RecordCode]) <= '" & VRecordCode & "' AND [TransactionTypeID]= '2')
Paul
------ Original Message ------
From: "Youssef" <youssef2309@gmail.com>
Sent: 3/9/2022 9:37:30 AM
Subject: Re: [MSAccessProfessionals] Syntax error
Dear Mr. Paul,
thanks for your support
I've updated the syntax and still get the message (expected: list separator or ) )
I can't notice the mistake
please support again
TotalDebit = DSum("[AmountDebitFrom]", "Qry_TransactionsFullData", "[AccountID] = '" & txtAccountID & "'" & " AND Val([RecordCode]) <= " & VRecordCode & " AND [TransactionTypeID]= '" & 2 & "'" & ")thanks in advance
Tidak ada komentar:
Posting Komentar