469,341 Members | 6,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,341 developers. It's quick & easy.

how to select latest updation from Ms Acess

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.....
Jan 10 '07 #1
2 1289
bartonc
6,596 Expert 4TB
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.
Jan 10 '07 #2
ronverdonk
4,258 Expert 4TB
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:
Jan 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.