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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rookiesql

    Link Visio object to specifc place in Word document

    Hi Tony, I found out how it works and that I can just enter the bookmark name. Now my new problem is that there seems to be a function in my company's word template that positions to the start of the document. Is this a changeable feature in a Word template? So what happens now is that the...
  2. rookiesql

    Link Visio object to specifc place in Word document

    I am writing a process description in Word and drafting an associated process chart in Visio. I would like to link from the Visio shapes representing activities to the related activity description in the Word document. In Visio I can set up a link to the Word dokument and there is a "sub...
  3. rookiesql

    EXCEL cell reference problem

    Hi, I looked in the SUMPRODUCT threads but couldn't see the solution. To be more specific about my problem: My data (which is customer error reports) looks basically like this: C1 C2 C3 C4 id submit date solution date time2solution I want to calculate the...
  4. rookiesql

    EXCEL cell reference problem

    Hi! I have a big excel sheet with a lot of data that use to present various statistics. Each record is a row and the are sorted after creation date which is one of several columns. Now I wanted to do the following: search one of the columns for specific contents (for example date (not creation...
  5. rookiesql

    Getting result in local time from UTC

    Hi! I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an...
  6. rookiesql

    Retrive time in local time not UTC

    I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an expression...
  7. rookiesql

    Changing what data is viewed in multiple EXCEL charts

    Ok, I understand the concept of using a name and that the suggestion creates a reference to the complete data matrix. Unfortunately in my case it is more complex. A typical source data for my charts look like this: =sheet1!$A$1:$U$1;sheet1!$A$3:$U$3;sheet1!$A$6:$U$6;sheet1!$A$10:$U$10 ...and...
  8. rookiesql

    Changing what data is viewed in multiple EXCEL charts

    OK, the hide columns approach works, thanks for that! However, another problem is when I add the data for another month at the right of the matrix. How can I modify all my charts (maybe 50 of them) to show also the new months data, without editing the selection of source data for each and every...
  9. rookiesql

    Changing what data is viewed in multiple EXCEL charts

    My problem is the following: I have a big matix of data with the folowing structure: Jan Feb Mar ... data1 ... ... ... ... data2 ... ... ... ... data3 ... ... ... ... .... From this matrix I have generated a big number of charts with different data vs. the months, i.e...
  10. rookiesql

    Linking/importing EXCEL charts into POWERPOINT

    I have generated a lot of charts, which resides inside a MS EXCEL file. These charts are updated regularly and I need to present the results. Questions: 1. Can I import these charts into my PPT file in a more automatic fashion that what I use now, i.e. select the chart in EXCEL, Copy and paste...
  11. rookiesql

    SELECT statement in SELECT statement?

    Sorry for my phrasing. Indeed your suggested syntax did work!! Thanks very much! I have been iterating my SQL statement using MS Query, which is the tool at hand. The resulting statement is like this: SELECT T1.id, T1.submit_date, T1.severity, T1.verification, MAX(case when...
  12. rookiesql

    SELECT statement in SELECT statement?

    Hi again, Back again in the forum after attending to some other stuff. I did try the construction suggested by swampBoggie (having a case statement within a max function in the select statement), but it does not seem to work on my system. swampBoggie wrote "You never stated which DBMS you...
  13. rookiesql

    SELECT statement in SELECT statement?

    Hi! Wow very fast replies! Sorry I was not specific, but I am a SQL rookie. Let me try to be more specific: What I can easily get with a standard query is a result like this: PROBLEMID State time_stamp #1 start 2003-04-01 #1 finish 2003-05-23 #1 close...
  14. rookiesql

    SELECT statement in SELECT statement?

    Hi! I am trying to extract data from a Problem DB in SQL. The Problems in the database pass through different states as they are treated. The states are named and there is an associated time stamp for each state. In my query I want to SELECT the Problem id and then the time stamp for 3 different...

Part and Inventory Search

Back
Top