-
1. Re: Display first and last record of the recordset in a Header
bregent Sep 23, 2011 12:29 PM (in response to Crystal_Rouse)select max(mydate), min(mydate) from mytable where.....
Hard to give better advice without more details...table structures, etc.
-
2. Re: Display first and last record of the recordset in a Header
Crystal_Rouse Sep 23, 2011 12:33 PM (in response to bregent)Thanks. This would work in the query but I need to know how to write this to show the MAX Date and MIN Date using ASP from the recordset.
-
3. Re: Display first and last record of the recordset in a Header
bregent Sep 23, 2011 3:41 PM (in response to Crystal_Rouse)You mean you just want to use a single recordset to display the min/max, and also display all of the records in a repeating region? You could produce the recordset sorted by date, navigate to the first record and store in a variable, then navigate to the last record and store in another variable.
-
4. Re: Display first and last record of the recordset in a Header
Crystal_Rouse Sep 26, 2011 6:02 AM (in response to bregent)Thanks for your reply. I want to display the repeating recordset and have the first and last record show in a title at the top of the repeating recordset. Do you have an example of how to store the first and last record in a variable?
Thanks so much for your help!
-
5. Re: Display first and last record of the recordset in a Header
Crystal_Rouse Sep 26, 2011 8:25 AM (in response to bregent)Thanks for this suggestion. I figured it out. I was making it harder than it really was.


