I guess there are many ways. But try:
WHERE DTOC(batchdate, 1) <= DTOC(thisform.txtsdate.value, 1)
-- SNIP --
>I tried e.g :
> where batchdate <= DTOT(CTOD(DTOC(thisform.txtsdate.value) + ' 23:59')
> but it still does not help.
>Any help?
HTH,
- Erik Niese-Petersen
Crazy Dane in USA.