Hello,

i use access 2002
i created datarows with a timestamp (18.07.2007)

My Query is ..

SELECT DISTINCT *
FROM tData p
WHERE p.timestamp#31/07/2007#

It works.


But ..
SELECT DISTINCT *
FROM tData p
WHERE p.timestamp#02/08/2007#

Here i have no result


But...

SELECT DISTINCT *
FROM tData p
WHERE p.timestamp#08/08/2007#
...works fine.

When my Day is smaller 8 i got no result.

Could anybody help me ?


greetings
Martin