Search results for query: *

They do have Crystal Reports hooked into the back-end where I work. I'm assuming I will need to create the pop-up there. SQL runs on the back-end of a commercial product, and queries can't be run there.

I'm sorry, I'm transitioning from doing most of my SQL queries in ACCESS. I am now solely in SQL server, without another application to fall back on. I have this query (below), and in Access I could use a parameter to turn these lines in my following SQL query and gifteffdat>'2005-03-31...

I currently have a unique ID# in a table, with many other queries and tables attached to it. When I change the unique ID I have to change it in about 10 different queries to make sure it updates all the necessary tables. I want to enter some code or use a macro that, once I decide I am going...

Zathra - you are awesome! That code worked perfectly - and you were right, I actually did have some other information in the other columns, but I was able to get rid of that by repeating the same code! Now that you've made my life hugely simpler, all I need to do is add a blank row every time...

I am trying to use Skip's and Zathras code for text I am bringing into Excel (very useful); however, I can't get the code to work. I am bringing in through Excel's clipboard 12 blocks of text, that are each between 9-11 lines. I am trying to subtract all but 12 lines, to extract what I need...