Peculiar query issue

[finglem]

Hi Guys wonder if anyone can help.

I have two databases. structure is exactly the same (just link to different websites). I run a query on one database and get the expected results.

Run the exact same query on the other database and i get errors. Either data type mismatch errors or driver might be out of resources??

Anyone got any ideas? Just to show how simple the query is :

SELECT Order.* FROM [Order] WHERE (DateValue([order].[Date Ordered])>#01/01/09#)

Thanks

 

[MajP]

any chance [date Ordered] is a number or actual date? If it is not a string you will get the type mismatch error. Any chance [date ordered] returns a null? You would get an invalid use of null error, and maybe another error message.