472,127 Members | 1,915 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

how to select latest updation from Ms Acess

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
Jan 10 '07 #1
2 1410
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
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.