data type mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.....?
 
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.
 
Thanks....that worked

Brendan Reynolds said:
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.
Click to expand...
 
Back
Top