Search results for query: *

Among the built-in options for Excel footers is the filename and tab description. I like to put those in each of my document so people can find the file again later. But it is not always obvious which network directory contains the file so I'd like to add the full pathname to the footer. Is...

I have a range called SCORES, with numeric values 0 to 100. I want to see how many scores are between (inclusive) let's say 70 and 79. And basically every other range of possibilities in 10 point increments. So I thought I'd use column D for the minimum point of any given range, and column...

When I press snooze on a calander alarm I'm expecting it to pop back up in 5 minutes like I told it. Instead it pops back up anywhere from 10 seconds to 2 minutes or so. Wildly inconsistent. Any ideas? Second issue, be a hero to many. Is there any way to pick a snooze interval longer than...

I have a table of data, 12 columns of months and 8 rows of data. I want a chart with months as the X axis and values on the Y axis. I further want the first seven rows to be a stacked bar for each month, and the last row to be a line superimosed across the stacked bars. A stacked bar chart is...

My organization has several SQL databases. I can establish connections to them through Enterprise Manager by typing in their IP addresses in the NEW box and completing the wizard, but then under my SQL Group I end up with several databases identified only by their IP addresses. Is there a way...

I started by reading vongrunts's excellent FAQ on random numbers. Highly recommended! For my application, I need random integers 0 - 9 inclusive. The following code looks like it will work for me, it is lifted almost straight from vongrunt's FAQ. A couple of things I ran into that might be...

I have a blank field in one table that I want to update based on information in another table. The tables are related and the subquery in my SET = clause returns the right information, but I get the error that my subquery cannot return more than one value. How can I relate the list of...

I imported an Excel spreadsheet which had 46 columns of genuine data, and another 100 or so columns of nothing, but the DTS Wizard assigned all those bogus columns field names (F47, F48, F49...) and inlcuded them with NULL values in my table anyway. Now the easy thing to do would be to just...

I noticed in gmmastros reply to the surgery 35 day calander question that he used a variable defiend as a table. New one on me so I decided to see if I could create a variable table and join it to an existing table. What I found was that while I could create the variable table and see what was...

New Federal Guidelines mandate that we allow each of our students to identify themselves as being a member of at least 1 Race, and as many as 5. We're using a commercial database where the vendor has seen fit to make 1 record per student in the STUDENT table, and multiple records for each...

I have a situation where one table (STD_DEMO) has one record, and another table (STD_PRGMS) has multiple records for that student, each with a unique START_DATE. I need to return the name of the student, but only if their earlist program start date occurred before 3/14/02. SELECT...