how to select latest updation from Ms Acess

[sonasiva]

hai
Iam creating my own website using ASP and MS ACESS ,iam new to ASP and SQL
Please help me to write a query to finish my project.

i have datas as follows in my database
sno name companyname shares percentage date
1 aaa kroft 5000 5 1/1/2007
2 aaa kroft 10000 10 1/9/2007

if i click "name" link the deatils should display like this

aaa holding
sno companyname shares percentage date
1 kroft 10000 10 1/9/2007

As u can see only latest data was displayed


i have written the query as follows
my_SQL = "SELECT companyname,MAX(date) AS date,shares,percentage FROM [data]"_
&"where name='"&request.querystring("name")&"'"&" order by date ()"


thanks in advance
sona.....

[bartonc]

The Access forum is here. There are many Access experts there. This is the MySQL forum. MySQL is an open source database NOT made by Microsoft.

[ronverdonk]

This is a double post with a different title in the MySQL forum!! The duplicate thread will be removed.

This thread will be moved to the Access forum.

moderator :cool: