Last post Apr 05, 2008 02:11 PM by Daveg232
Apr 03, 2008 10:48 AM|scot.saienni|LINK
I am very new to asp.net and visual web developer, and I am working on a very simple website. The site consists of an access database, a login page, and a main page. The main page pulls the data from the database and displays it in a gridview. There are
a total of 3 columns in the gridview named: Entry Date, Entry Time, and Name. These 3 columns are the names of the columns in the database. As of right now, I have a working dropdownlist that is populated with every unique name from the Name column in the
What I want to do is create an additional dropdownlist that will allow a user to further filter the gridview by the very first entry time per entry date, per name. Is there a way to add a second dropdownlist that uses a accessdatasource, but the accessdatasource
only selects the first entry time for each entry date?
Apr 03, 2008 03:14 PM|Daveg232|LINK
i might be oversimplifying the question but could you add a parameter to the access data source then add TOP 1 so it only returns the first record in the returning recordset
Apr 04, 2008 07:34 AM|scot.saienni|LINK
Too simple. I need 1 record for each Date that is associated with each Name
Date Time Name
4/3/2008 7:04am John
4/3/2008 6:45am John
4/4/2008 6:50am Dan
4/4/2008 6:45am Rich
How can I modify the select statement to show only the first date occurance per Name?
Apr 05, 2008 02:11 PM|Daveg232|LINK
Something like this maybe?
SELECT Last(Times.Date) AS LastOfDate, Last(Times.Time) AS LastOfTime, Times.Name
GROUP BY Times.Name;