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!

Recent content by Sql7user

  1. Sql7user

    IF Statement

    Thanks Skip, worked perfectly! /Sql7user
  2. Sql7user

    IF Statement

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

    aggregate function

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

    Aggregate function

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

    aggregate function

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

    Aggregate function

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

    Select statement problem

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

    Select statement problem

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

    Several dynamic listboxes

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

    Several dynamic listboxes

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

    Several dynamic listboxes

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

    Excel Subtotals

    Thanks for your excellent tips. It works perfect. Sql7user
  13. Sql7user

    Excel Subtotals

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

    Some kind of pop up window

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

    Null value problem with SQL-Server

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

Part and Inventory Search

Back
Top