data type mismatch

[Guest]

I thought maybe I should give more detail to my earlier question. I set up a
simple query using fields from three tables - customer, orders, order
details. My objective is to pull a list of all orders that have not shipped
yet. So, I set the ship date to null or "" and sorted the promise date by
ascending. This should give the warehouse a list of the most pressing orders
to ship out first.

But I'm getting a data type mismatch error.....?

 

[Brendan Reynolds]

I'm seeing this post in isolation, I have no idea what the earlier question
to which you refer might have been. But if 'ship date' is a Date/Time field
as the name implies, then a type mismatch is to be expected if you attempt
to compare it with a string. If you're comparing the ship date field with
Null or "", try changing the comparison to just Null.

 

[Guest]

Thanks....that worked

I'm seeing this post in isolation, I have no idea what the earlier question
to which you refer might have been. But if 'ship date' is a Date/Time field
as the name implies, then a type mismatch is to be expected if you attempt
to compare it with a string. If you're comparing the ship date field with
Null or "", try changing the comparison to just Null.