Query Specific Date

[ensorg]

Hi,

I have a table which contains a "Date/Time" field, the value of which is something like 02/10/2002 13:56:47

If I use the following query -
Between #01/10/2002# And #03/10/2002#
then it shows the data, but if I use the query -
= #02/10/2002#
I do not get any results.
How can I modify my query so I can get results for a specific date?

Thanks

 

[LittleSmudge]

Between #01/10/2002# And #03/10/2002#


MEANS Midnight at the START of 01/10/2002
to MIDNIGHT at the START of 03/10/2002

So if you want to include times during 03/10/20 then you'll need

Between #01/10/2002# And #03/10/2002 23:59:59#



'ope-that-'elps.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D