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 Mike Lewis 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: *

  1. timppap

    How to get only the last row

    Hi ! Would You give an examble so I understand ! Thanks !
  2. timppap

    How to get only the last row

    How I can get only the last from A and B or several more ? Name Dateperiod A 200301 A 200901 A 201001 B 200801 B 200901 B 201001 I want only A 201001 B 201001 Thanks!
  3. timppap

    Moving multiple rows to single row

    Thanks I try !
  4. timppap

    Moving multiple rows to single row

    I have this kind of data TiliA TiliB A 1 A 2 A 3 B 1 B 2 I want to get like this TiliA TiliB A 1 2 3 B 1 2 How to do it ? Thanks
  5. timppap

    How to calculate only bussiness days

    Ok I have to try ! It must work like this ! Today is example Wednesday 6.4 and the new_sasdate = 12.4 so the test day (new_sasdate - today())should be 3 !? Br Timo
  6. timppap

    How to calculate only bussiness days

    Hi ! I have following code new_sasdate = input(osjomtpv,yymmdd8.); ----------------- if new_sasdate - today() <= 5 then osinko ="DIVIDEND" ; TEST=new_sasdate - today(); if TEST < 0 then osinko ="" ; This calculate also Saturday and Sunday but I don't want that ? Thanks for any help !
  7. timppap

    How to import to access from excel named range vba

    Hi ! How to import from excel named range to access. examble aa.xls range a1..b2 to access "test" Br Timo

Part and Inventory Search

Back
Top