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!

Search results for query: *

  • Users: Sql7user
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. Sql7user

    Null value problem with SQL-Server

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

Part and Inventory Search

Back
Top