Data Type Mismatch

[Swannie]

Can anyone explain what is going on

If have the following SQL which I am writing into a string to run within code.

 SQL2 = "SELECT qryDiarySystemPartOne.[Date Received], " & _
                  "qryDiarySystemPartOne.[Full Policy], " & _
                  "qryDiarySystemPartOne.[Claim Number], " & _
                  "qryDiarySystemPartOne.[Policy Holder], " & _
                  "qryDiarySystemPartOne.[Complaint ID], " & _
                  "qryDiarySystemPartOne.[Days Open], " & _
                  "qryDiarySystemPartOne.[Diary Date], " & _
                  "qryDiarySystemPartOne.[Times Reopened], " & _
                  "qryDiarySystemPartOne.[Acknowledge], " & _
                  "qryDiarySystemPartOne.[Letter], " & _
                  "qryDiarySystemPartOne.[40Day] " & _
            " INTO tempDiary" & TableAppend(Me.cboUsers) & _
            " FROM qryDiarySystemPartOne " & _
            "WHERE ((((qryDiarySystemPartOne.[Days Open])=4 Or (qryDiarySystemPartOne.[Days Open])=5)" & _
            " AND ((qryDiarySystemPartOne.[Times Reopened])=0)" & _
            " AND ((qryDiarySystemPartOne.[Acknowledge])=False))) ";

Which runs OK

But when I add on

 " OR ((((qryDiarySystemPartOne.[Days Open])=19 Or (qryDiarySystemPartOne.[Days Open])=20)" & _
            " AND ((qryDiarySystemPartOne.[Times Reopened])=0)" & _
            " AND ((qryDiarySystemPartOne.[Acknowledge])=False)));"

I am getting a Data type mismatch error.

Does anyone know why ?

Cheers

Swannie

 

[CCIDBMNG]

Did you check to see if the fields Days Open and Times Reopened are numeric fields if they are text you need to place quotations around the number for example ((qryDiarySystemPartOne.[Times Reopened])="0").

 

[Swannie]

The field in question is a Boolean, so either 0 or -1.

As far as I am aware a Boolean is held as a numeric. If that is incorrect please tell me.

Cheers

Swannie

 

[Swannie]

What I was trying to do was search on a filed named [Letter] which I thought that was where I was getting the error. I changed this to Acknowledge, knowing that I had already searched on the criteria in this field with success.

The problem seems to be that after the "OR" it does not recognise the data type anymore.

Anyone know why.

Swannie