Malloy1446
asked on
Using Boolean logic in a SQL statement WHERE statement
I need to select records based on one criteria plus a 2nd variable criteria:
A and (B or C)
Currently my sql statement is:
sql2 = "SELECT COUNT(tblJournal.ChartID) AS CountEBSCO12NoContract " & _
"FROM tblJournal " & _
"WHERE tblJournal.FY12Vendor = 'EBSCO' AND tblJournal.FY12NatContract = 'No' OR " & _
"tblJournal.FY12Vendor = 'EBSCO' AND tblJournal.FY12NatContact IS NULL "
Set obj2 = Server.CreateObject("ADODB .Recordset ")
obj2.Open sql2, objConn
The error generated is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
A and (B or C)
Currently my sql statement is:
sql2 = "SELECT COUNT(tblJournal.ChartID) AS CountEBSCO12NoContract " & _
"FROM tblJournal " & _
"WHERE tblJournal.FY12Vendor = 'EBSCO' AND tblJournal.FY12NatContract
"tblJournal.FY12Vendor = 'EBSCO' AND tblJournal.FY12NatContact IS NULL "
Set obj2 = Server.CreateObject("ADODB
obj2.Open sql2, objConn
The error generated is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was deleting my question because I found the solution myself. At the same time someone was providing a possible solution.
WHERE tblJournal.FY12Vendor = 'EBSCO' AND tblJournal.FY12NatContract
"tblJournal.FY12Vendor = 'EBSCO' AND isNull(tblJournal.FY12NatC