Hi Fred ----
There was a thread going here weeks ago where it was shown a similar problem existed with SELECT - SQL on DateTime values insofar as no records would be returned even if there were records, until you converted the query into TTOC()
>
>
>I ran into this problem with some code that was adding non-integer values to dates. Boy, talk about a tough lesson to learn (and track down)!
>
>You look at the dates in the debugger and everything looks cool. I guess some things are more equal than others no matter how equal they may "appear".
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05