Hi everyone,
I am facing some problem with delimiters in my below sql
This will filter the Entrylist to be appear with Bank&Cash transactions only.
I am facing some problem with delimiters in my below sql
Code:
Private Sub chkBank_Cash_Click()
If Me.chkBank_Cash = True Then
Me.EntryList.RowSource = "SELECT tblEntries.EntryNo, tblEntryTypes.EntryType, tblEntryTypes.Bank, tblEntryTypes.Cash, tblEntryTypes.Customer, tblEntryTypes.Supplier, tblEntryTypes.Employee, tblEntryTypes.Owners"
FROM tblEntryTypes INNER JOIN tblEntries ON tblEntryTypes.EntryType = tblEntries.EntryType
WHERE (((tblEntryTypes.Bank) Like "*") And ((tblEntryTypes.Cash) Like "*") And ((tblEntryTypes.Customer) = False) And ((tblEntryTypes.Supplier) = False) And ((tblEntryTypes.Employee) = False) And ((tblEntryTypes.Owners) = False)) ";"
End If
This will filter the Entrylist to be appear with Bank&Cash transactions only.