I have used any number of vba statements as a filter in the WHERE clause like the one below. The usual cause of the missing operator for me was a missing "Quote" sign. I can't see what the cause of the error here. There is no text field:

"([PartID] = " & dblPartID & " AND [Size] IsNull) OR ([PartID] = " & dblPartID & " AND [Size] IsEmpty)"

[PartID] Type is Double; [Size] Type is integer.

(Bet the answer is probably obvious)

DaveLA

Hi

Is this as part of a WHERE clause in an SQL string in VBA ?

Anyhooo, I'd imagine the error is because of the way you're using the IsEmpty() function - you haven't passed a variable to it. It would be more like



but I don't really understand why you're doubling up the WHERE clause by saying [Size] IsNull and then IsEmpty([Size]) ? Couldn't you just say something like

Yes it is part of the Where clause in an SQL vba statement. I have tried both with and without the "IsEmpty", as well as "Is Empty" vs. "IsEmpty"

Avery simple statement, should work.

DaveLA

Hi

Easiest way to spot errors is to use the Immediate Window. If you asign your SQL statement to a string variable along the lines of

strSQL = "SELECT blah blah blah....."

you can put

Debug.Print strSQL

immediately after the full SQL is constructed. The full SQL with the variables evaluated will then be in the Immediate Window (Ctl + G) where you should be able to spot whatever's causing the problem

you could try



you seem to be passing [size] as text

"([PartID] = " & dblPartID & " AND (Isnull([Size]) OR [Size]=0))"