Search results for query: *

Thanks Skip, worked perfectly! /Sql7user

I have a little problem, someone could help me with. I want to use a if statement either in excel directly or in vba. With the if statement I want to mark all rows with a field containing for example "X". All the rows contains som figures or letters but only a few contains "X" and after the X...

Thanks both of you! Your really helped me out there! /Sql7user

Nice, it worked perfectly SkipVought. Hope I can get it right in the real query but this solved the problem. Thank you so much!

Hi I have a problem with a aggregate function in a query, and that I hope someone can help me with. The hole query is way more complex than this but i have cut out the problem part. I have 3 fields as below. As you can see the article field is not uniqe. Article, Price, Date of Pricing A01...

Hi I have a problem with a aggregate function in a query, and that I hope someone can help me with. The hole query is way more complex than this but i have cut out the problem part. I have 3 fields as below. As you can see the article field is not uniqe. Article, Price, Date of Pricing A01...

Thanks too both of you for your good solutions. /Sql7user

Hi, I have a problem with a select statement that I have no idea how to solve. I´m going to try to explain the problem. I have a query where the fields are: Article Nr, Machine, Batch, Material Nr, Quantity. I have some creterias where I can search out for example, all batches for a specific...

Thanks Gleen!!! There were many nice solutions for me to solve my problem. Cheers, Sql7user

Hi, In Excel I want to put 2 or more listbox/combox that are dynamic and linked. Depending of the choice I make in the first i get choices in listbox 2 etc. For example, I choose countries in listbox 1, get the cities in number 2 and in number 3 I get the streets. I have no idea how to make...

Hi, In Excel I want to put 2 or more listbox/combox that are dynamic and linked. Depending of the choice I make in the first i get choices in listbox 2 etc. For example, I choose countries in listbox 1, get the cities in number 2 and in number 3 I get the streets. I have no idea how to make...

Thanks for your excellent tips. It works perfect. Sql7user

Hi, I have a problem with the subtotals function in Excel. Lets say I have 3 columns, and want to add subtotals for all 3. If I use ex SUM function for all 3 theres no problem but if I want to make column 1 and 2 with SUM and the third with Average? Is this possible without having to do the...

Hi, I have been programming a application in Excel VBA where I have some choises on the first page (for ex date) then I use a ADO connection to a SQL server where I get out the data of my choises. Finally, based on the data, a graph is coming up showing up the result. Here is the question, it...

Thank you for your fine solutions. Ive got another solution from another forum too: In the data transformation properties under advanced there is check box for "Enable identity insert". If I check that box the transformation is working without complains, but can there be other...

I´m trying to grab tables from an AS/400 to an SQL-server7 via odbc (client access) connection. To do this I have set up DTS packages that copy the data (mirror) from one table and then drops the data in the sql table the next day and copy it again. On a few packages it works fine but here is...