Search results for query: *

Hey, I just did a clean install of XP on an old dell d630 laptop from the system restore disks that came with it. Problem is, I can't find the original XP license key--the one printed on the bottom of the laptop is for vista. I have access to a site license key through my university, but the...

Thanks, I'll try that. I guess it's too bad that I can't use the easy built in functions =)

This particular application is much better suited to excel than access; namely, it does large amounts of calculations on large data sets, generates graphs and statistics. The only hiccup is that while in the past, it referenced cells in another workbook file, it now must reference a table on an...

The connection to the SQL server data source is one-way only. I am only trying to read data from the server, put it in a named range (both of which are nicely automatic, it seems), and then other code on the worksheet references this range in a VLOOKUP and displayes derived information based on...

Hello, I am trying to setup an ODBC connection to MS SQL Server from an Excel 2003 workbook. Whenever the workbook is in non-shared, single-user mode, the connection works fine and the linked data can be refreshed, etc.; but when shared mode is activated the data becomes static and the...

Thank you very much!!

Hello, I am trying to create a view that sums data from two tables in this fashion: Table 1: A 3 B 5 C 1 Table 2: A 1 C 1 D 3 To produce: A 4 B 5 C 1 D 3 What is the best way to do this? I have tried using unions, outer joins, but I can't seem to get it to work--I keep running...

Thanks--you solved my problem completely!

Thanks George, your reply in the other thread was very helpful!

Hi, I'm relatively green at SQL queries, and I was wondering what the best way to construct a t-sql query on this data: table: activitylog fields: serial#, starttime, stoptime, activity 'serial' is non-unique, 'serial' + 'starttime' is unique. I need a query that will return, for each serial...

Hi, I'm relatively green at SQL queries, and I was wondering what the best way to construct a t-sql query on this data: table: activitylog fields: serial#, starttime, stoptime, activity 'serial' is non-unique, 'serial' + 'starttime' is unique. I need a query that will return, for each serial...