Without more context, it's a little hard to help. But here is the SQL for a simple Access query that would do what you're mentioning.

SELECT MyData.*
FROM MyData
WHERE ([MyData].[Date] > #5/25/1969#);


Kynan C


-----Original Message-----
From: Goutam Ghoshal [mailto:mssqldba-ezmlmshield-x52993964.[Email address protected]
Sent: Wednesday, February 28, 2007 1:02 AM
To: LazyDBA Discussion
Subject: Access Date query

Hi All

I have an Access DB
And there are some date/time fields in some tables.
But i have some problem to get data based on date query

Like in sql server we have lots of option to fetch data based on date fieds (we can use convert etc)

suppose in a table there is a field name DOB
i want to fetch data whose DBB > '05/25/1969' ('mm/dd/yyyy')

How i get those records?

Regards,

Goutam




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page