Search results for query: *

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.

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

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

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

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.

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

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

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