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!

Search results for query: *

  1. whatcom

    Double each row, and then append a column

    Thanks PHV. That gave me a start. I wound up creating two separate tables. For the first table, I added a "h". For the second, I add a "b". Then, I created a new table, and did a "insert into" and unioned those two tables together. Thanks for giving me a start on this.
  2. whatcom

    Double each row, and then append a column

    Hello I have a sql table which has three columns. The combined columns work as the primary key. The table has data similar to: No Case Code 111 ADM GAD 112 ADM TRM 113 BSP RLR Essentially, what I would like to do is to double up every row, and then add a "B" and an "H" to the end of each...
  3. whatcom

    Duplicate Records

    Ok - I'll give it a shot. Thank you so much.
  4. whatcom

    Duplicate Records

    Hi. I have a table (called TAB1), that has just two columns (New#, Old#). The purpose of this table is to associate old fee numbers from 2008 with the new fee numbers for 2009. For some reason, this table got a bit messed up, and some of the old numbers are duplicated. A sample of the...
  5. whatcom

    Printing on a different paper size per worksheet in Excel

    I'm sorry all. It appears I made the "new" person mistake by not trying it first. It looks like you can do it. I tried to delete the post as soon as I posted, but was unable do.
  6. whatcom

    Printing on a different paper size per worksheet in Excel

    I have two worksheets in my Excel file - and I am printing to a PDF (so - no actual printer is involved). I would like one worksheet to have the paper size set to print in "legal" format, and I would like the other to be set to print in "letter" format. It seems that I have to choose either...
  7. whatcom

    Excel Query

    Ok - I'll give it a shot. Thanks!
  8. whatcom

    Excel Query

    Hello. I am trying to query data from a SQL Server into Excel. To keep things simple, I am just trying to query one table, and look at three fields: NUMBER, TYPE, DATE. In the Query Wizard, I set up the Filter Data screen, and then the Sort Order screen. Once that is done, I click the...

Part and Inventory Search

Back
Top