Begginer needing help to resolve error.

Hi,
I hope one of you may be able to help me with a small probelm I have.
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression '[Date_Completed]
is NULL WHERE (([Customer] LIKE '%Davie%' OR [Address] LIKE '%Davie%'
OR [Post_Code] LIKE '%Davie%' OR [Telephone] LIKE '%Davie%' OR
[Mobile] LIKE '%Davie%' OR [Vehicle] LIKE '%Davie%' OR [Chassis_No]
LIKE '%Davie%' OR [Engine_No] LIKE ''.
/Jobsheet/Datalist.asp, line 227
The code that it highlights is this:
<%
' Set up Record Set
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.Open sSql, conn, 1, 2 --This line in particular --
nTotalRecs = rs.RecordCount
If nDisplayRecs <= 0 Then ' Display All Records
nDisplayRecs = nTotalRecs
End If
nStartRec = 1
SetUpStartRec() ' Set Up Start Record Position
%>
I would be much obliged if anyone can provide assistance.
Cheers,
PhillIs it Access query?
"FatboyDim" <webmaster@.pb-enterprises.co.uk> wrote in message
news:1183454575.272248.54230@.c77g2000hse.googlegroups.com...
> Hi,
> I hope one of you may be able to help me with a small probelm I have.
> I get the following error:
> Microsoft JET Database Engine error '80040e14'
> Syntax error (missing operator) in query expression '[Date_Completed]
> is NULL WHERE (([Customer] LIKE '%Davie%' OR [Address] LIKE '%Davie%'
> OR [Post_Code] LIKE '%Davie%' OR [Telephone] LIKE '%Davie%' OR
> [Mobile] LIKE '%Davie%' OR [Vehicle] LIKE '%Davie%' OR [Chassis_No]
> LIKE '%Davie%' OR [Engine_No] LIKE ''.
> /Jobsheet/Datalist.asp, line 227
>
> The code that it highlights is this:
> <%
> ' Set up Record Set
> Set rs = Server.CreateObject("ADODB.Recordset")
> rs.CursorLocation = 3
> rs.Open sSql, conn, 1, 2 --This line in particular --
> nTotalRecs = rs.RecordCount
> If nDisplayRecs <= 0 Then ' Display All Records
> nDisplayRecs = nTotalRecs
> End If
> nStartRec = 1
> SetUpStartRec() ' Set Up Start Record Position
> %>
> I would be much obliged if anyone can provide assistance.
> Cheers,
> Phill
>|||Yes,
It is an Access query.
On 3 Jul, 10:27, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Is it Access query?
> "FatboyDim" <webmas...@.pb-enterprises.co.uk> wrote in message
> news:1183454575.272248.54230@.c77g2000hse.googlegroups.com...
>
> > Hi,
> > I hope one of you may be able to help me with a small probelm I have.
> > I get the following error:
> > Microsoft JET Database Engine error '80040e14'
> > Syntax error (missing operator) in query expression '[Date_Completed]
> > is NULL WHERE (([Customer] LIKE '%Davie%' OR [Address] LIKE '%Davie%'
> > OR [Post_Code] LIKE '%Davie%' OR [Telephone] LIKE '%Davie%' OR
> > [Mobile] LIKE '%Davie%' OR [Vehicle] LIKE '%Davie%' OR [Chassis_No]
> > LIKE '%Davie%' OR [Engine_No] LIKE ''.
> > /Jobsheet/Datalist.asp, line 227
> > The code that it highlights is this:
> > <%
> > ' Set up Record Set
> > Set rs = Server.CreateObject("ADODB.Recordset")
> > rs.CursorLocation = 3
> > rs.Open sSql, conn, 1, 2 --This line in particular --
> > nTotalRecs = rs.RecordCount
> > If nDisplayRecs <= 0 Then ' Display All Records
> > nDisplayRecs = nTotalRecs
> > End If
> > nStartRec = 1
> > SetUpStartRec() ' Set Up Start Record Position
> > %>
> > I would be much obliged if anyone can provide assistance.
> > Cheers,
> > Phill- Hide quoted text -
> - Show quoted text -|||Hi
Its SQL Server news group. You will be better of ask the question in Access
group
"FatboyDim" <webmaster@.pb-enterprises.co.uk> wrote in message
news:1183455450.654505.196030@.n2g2000hse.googlegroups.com...
> Yes,
> It is an Access query.
> On 3 Jul, 10:27, "Uri Dimant" <u...@.iscar.co.il> wrote:
>> Is it Access query?
>> "FatboyDim" <webmas...@.pb-enterprises.co.uk> wrote in message
>> news:1183454575.272248.54230@.c77g2000hse.googlegroups.com...
>>
>> > Hi,
>> > I hope one of you may be able to help me with a small probelm I have.
>> > I get the following error:
>> > Microsoft JET Database Engine error '80040e14'
>> > Syntax error (missing operator) in query expression '[Date_Completed]
>> > is NULL WHERE (([Customer] LIKE '%Davie%' OR [Address] LIKE '%Davie%'
>> > OR [Post_Code] LIKE '%Davie%' OR [Telephone] LIKE '%Davie%' OR
>> > [Mobile] LIKE '%Davie%' OR [Vehicle] LIKE '%Davie%' OR [Chassis_No]
>> > LIKE '%Davie%' OR [Engine_No] LIKE ''.
>> > /Jobsheet/Datalist.asp, line 227
>> > The code that it highlights is this:
>> > <%
>> > ' Set up Record Set
>> > Set rs = Server.CreateObject("ADODB.Recordset")
>> > rs.CursorLocation = 3
>> > rs.Open sSql, conn, 1, 2 --This line in particular --
>> > nTotalRecs = rs.RecordCount
>> > If nDisplayRecs <= 0 Then ' Display All Records
>> > nDisplayRecs = nTotalRecs
>> > End If
>> > nStartRec = 1
>> > SetUpStartRec() ' Set Up Start Record Position
>> > %>
>> > I would be much obliged if anyone can provide assistance.
>> > Cheers,
>> > Phill- Hide quoted text -
>> - Show quoted text -
>