Query criteria Type Mismatch

[John_G]

There is a missing space before FROM, but I don't think that is the issue; I doubt if there really is a missing space.

Beyond that, I see nothing in the query that could cause an "invalid use of Null" error, so it has to be in the calculated field in the table.

Try replacing all Null values for [Qty] and [ReturnedQty] with zeros. In SQL, it would be:

Update [Load Lists] set [Qty] = 0 where [Qty] is Null

and



Update [Load Lists] set [ReturnedQty] = 0 where [ReturnedQty] is Null


Based on what you have shown, that should work.

John

[wolfm]

There is a missing space before FROM, but I don't think that is the issue; I doubt if there really is a missing space.

Beyond that, I see nothing in the query that could cause an "invalid use of Null" error, so it has to be in the calculated field in the table.

Try replacing all Null values for [Qty] and [ReturnedQty] with zeros. In SQL, it would be:

Update [Load Lists] set [Qty] = 0 where [Qty] is Null

and

Update [Load Lists] set [ReturnedQty] = 0 where [ReturnedQty] is Null


Based on what you have shown, that should work.

John

I tried these updates, and still no luck. I'm thinking that perhaps some of my data is corrupted. I think my work-around is going to export my query to excel and use excel filters to remove the positive and zero value. Unfortunately, a few extra steps.

[John_G]

Hi -

I'm beginning to wonder if that "invalid use of null" error is even bing generated by the query. Are you getting that error if you run the query from query design view? Or, are you opening the query from VBA? If you are using VBA, then there is a chance (quite a good one, actually) that the error is coming from somewhere else in your code, after the line that opens the query.

John