Query by a certain date

[Reaper]

I want to create a query that will give me all records from a certain date. The table being queried stores the date/time in general format, which includes both date and time.


When I enter query criteria to filter the date I get no records. For example, if I put in 4/26/2012 as the criteria, I get no records. I'm assuming it's because I haven't matched
the whole field.

How can I enter criteria in the query to get the all records from the table on a given date?

[orange]

All records from a certain date

SELECT * from yourtable where yourtable.yourDatefield > the date involved

eg. suppose I want records where the LastChangedDate is greater than 30 September 2011

SELECT * FROM MYTable where LastChangedDate > #9/30/2011#

the # delimiters are required for Date datatype values

[Reaper]

Thanks for your reply.

Not quite what I wanted. I want to select all records from an exact date, ie; 4/26/2012 from a field that stores the date in General Date format.
This query will be used to populate a report containing the transactions from a particular date. The date will be user selected from a form and the
date passed to the query.
I think your example will give me everything after the date.

[June7]

Then use = sign.

The field has time parts saved? Then extract the mm/dd/yyyy. Is report RecordSource a query? Calculate a field that extracts the mm/dd/yyyy

LCD: CDate(Format(datefield,"m/d/yyyy"))

Then:

DoCmd.Open "formname", , , "LCD=#" & Me.datetextbox & "#"

[Reaper]

Got it, thanks.

[orange]

Glad you got it. I see now that I misunderstood your " from a certain date"