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 TouchToneTommy 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: straatlang
  • Content: Threads
  • Order by date
  1. straatlang

    compare ?

    Hi, I hope someone can help me out? I have two columns A 1 2 3 4 5 6 10 and B 1 2 4 5 6 I would like to compare the two columns. The result I would like to see is 3,10
  2. straatlang

    Select from where

    Hi, Maybe someone can help me out with the following. I have to tables I need to know the missing numbers. Table A NRA 1 1 2 2 2 3 3 4 4 5 5 7 7 7 7 Table B NRB 2 2 2 3 3 3 3 5 I would like to see which number is not present in B the result should be shown ones so the result should...
  3. straatlang

    select from securities

    I hope someone can help me with the next problem. I have a table bookings NR ID Quantity SECNAME ID 1001 1 1000 abc 5 1002 2 2000 def 6 1003 3 3000 ghj 7 1004 4 4000 klm 8 and a table names ID Type country 1 Client US 2...
  4. straatlang

    Select from where max(date) valuation in EUR

    I hope somebody can help me with the next problem. There are three tables involved: Table: movements. Value Date Account Amount Cur DRCR 1-1-2003 123 2000 EUR CR 1-2-2003 456 1500 EUR CR 1-2-2003 123 1450 USD CR 1-4-2003 456 1250 EUR CR 1-7-2003...
  5. straatlang

    Select max(date) ???

    I hope somebody can help me with the next problem. Table: movements. Value Date Account Amount Cur DRCR 1-1-2003 123 2000 EUR CR 1-2-2003 456 1500 EUR CR 1-2-2003 123 1450 USD CR 1-4-2003 456 1250 EUR CR 1-7-2003 123 800 USD CR...
  6. straatlang

    Select from an other table and ........

    Hi, I want to extend the query and join some tables to be able to have a report with the name of each account and the exchange rate of the currency. And finally I want to see the total value in EUR in a seperate column. This is table movements. Value Date Account Amount Cur DRCR 1-1-2003 123...
  7. straatlang

    Select From ? Account Balance

    I Want to make a query and the result should calculate the total balance per Accountnumber per Value date by entering a Value date. Table: Movements Value Date Accountnumber Amount Cur DR/CR 01-1-2003 123 2000 EUR CR 01-2-2003 456 1500 EUR CR 01-2-2003 123 1450 USD CR 01-4-2003 456 1250...
  8. straatlang

    SELECT MAX(DATE)

    I want to create query from three Tables Marketprices, security and currency ? Marketprices SECURITY PRICEDAT PRICE ABC 12/12/02 10 ABC 13/12/02 11 ABC 14/12/02 10 DEF 15/12/02 20 GHJ 13/12/02 21 Securities...
  9. straatlang

    SELECT FROM WHERE

    have two tables : Articles ID Name 123 AAA 456 BBB 789 CCC 888 DDD Prices ID Price 123 10 456 20 789 30 999 40 The query should result in a list where all information that is available is visiable. SO infact...
  10. straatlang

    SELECT FROM ? HOW

    I have two tables : Articles ID Name 123 AAA 456 BBB 789 CCC 888 DDD Prices ID Price 123 10 456 20 789 30 999 40 The query should result in a list where all information that is available is visiable. SO infact in need to combine these two tabels. ID Name Price...
  11. straatlang

    Include company names with empty fields

    I want to create query from three Tables Marketprices, security and currency ? Marketprices SECURITY PRICEDAT PRICE ABC 12/12/02 10 ABC 13/12/02 11 ABC 14/12/02 10 DEF 15/12/02 20 GHJ 13/12/02 21 Securities...
  12. straatlang

    Select Distinct Security

    Who can help me with this problem. I want to create query from the Table Marketprices ? SECURITY PRICEDAT PRICE ABC 12/12/02 10 ABC 13/12/02 11 ABC 14/12/02 10 DEF 15/12/02 20 GHJ 13/12/02 21 GHJ 16/12/02...

Part and Inventory Search

Back
Top