Search results for query: *

Thanks, I hadn't thought of moving through the record set like that.

I'm rewriting some ASP for our corporate intranet and there is a lot of redundant information that appears in the "News" section (Populated from an SQL server that I don't have access too) Information such as "date submitted" that I think should be rolled up into a single header. What I have is...

Perfect answer, thanks Tony. Saved me from having to write something myself!

Conditional formatting seems limited to a cell-by-cell basis, or the formula that you're allowed to enter is so limited as to be useless, unfortunately.

I have a large spreadsheet (30,000 rows or so) of client data. It's been outputted as a simple CSV file and imported into excel where I'm massing it to make it look a little more presentable. The problem I've run into is I'm trying to highlight client-level information while leaving the specific...

Thanks for the input Carp. I had thought of that solution myself. The problem was that I'd have to change the number of rows to return each month. I need something static that goes back to January 2000 and I'm having a doozy of a time thinking of it.

I've taken over an XSQL/XML application and I've ran into an odd little work-around by a former employee that I'd like to reduce to a more simple solution. I need a list of months, in order from Current Month all the way back to, say, January 2000. The old solution was: SELECT...

Semi tough question that's been bugging me for a week. I have three dates, a created date, a current date and an end date. What I need is to find out what percentage complete the current date is at. IE...Started on Monday, Ending on Friday, it is currently Wednesday so the percent complete is...

I'm attempting to summarize date information for an exception based report and am running into several difficulties. The report I have currently creates an exception for a day based on specific criteria. This is display in the details section of the report. The group above is based on...