A Query that returns all Record for only Last date

[yameen2011]

Hi friends i want to write a query that display records for only last date entered in a table and i want to show all the records from last date entries in a table. sample attached.
Thanks.

 

[Brianwarnock]

First run a query to find the max date in the table , then join this to the table to select all records that match.

Brian

 

[yameen2011]

thanks for response, can you give me a example of a such query based on my sample.

 

[Brianwarnock]

I don't have ACCESS at the moment but it would be like so

Myquery
Select max(mydate) as MaxOfmydate
From mytable

Query2. Which you run

Select *
From mytable inner join myquery on mytable.mydate= myquery.MaxOfmydate

Brian

 

[jdraw]

Another

SELECT Student.ID
, Student.StdName
, Student.PostDate
FROM Student
WHERE
 (((Student.PostDate)=(Select Max(postdate) from student)));

 

[Brianwarnock]

Strange how people love their subqueries. There was a discussion on here a few years ago explains why stacked queries are usually more efficient but I can never find it. I prefer them as it is easier to write and debug.

I did find this

http://www.experts-exchange.com/Database/MS_Access/Q_28210046.html

 

[yameen2011]

Another

SELECT Student.ID
, Student.StdName
, Student.PostDate
FROM Student
WHERE
 (((Student.PostDate)=(Select Max(postdate) from student)));

thank you very much it works for me.