Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattjp

  1. mattjp

    Win XP License Key

    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...
  2. mattjp

    ODBC in a Shared Excel Workbook

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

    ODBC in a Shared Excel Workbook

    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...
  4. mattjp

    ODBC in a Shared Excel Workbook

    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...
  5. mattjp

    ODBC in a Shared Excel Workbook

    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...
  6. mattjp

    Data combination

    Thank you very much!!
  7. mattjp

    Data combination

    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...
  8. mattjp

    Simple SQL grouping question

    Thanks--you solved my problem completely!
  9. mattjp

    Simple Grouping Query Question

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

    Simple Grouping Query Question

    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...
  11. mattjp

    Simple SQL grouping question

    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...
See more

Part and Inventory Search

Back
Top