By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,997 Members | 507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,997 IT Pros & Developers. It's quick & easy.

how to select latest updation from Ms Acess

P: 15
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
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 6,596
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

Expert 2.5K+
P: 4,258
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.