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 Rhinorhino 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 kingz2000

  1. kingz2000

    Bound/unbound forms

    Hi everyone, I currently have a form bound to a table. I have created a save button, because I need to set a flag when I save a dataset. To be more precise I need to add the user to a column of the dataset. So I want to disable the automatic save procedure of saving in a bound form. I tried to...
  2. kingz2000

    connection - runtime error (Excel to SQL-Sever)

    thanks dude
  3. kingz2000

    connection - runtime error (Excel to SQL-Sever)

    HI Guys, I'm getting a connection problem when I try to open an adodb.connection to SQL-Server Run-time error 2147217805(80040e73) Format of the initialization string does not conform to the OLE DB specification I get the error on the con.open statement. Here is my code: Private Sub...
  4. kingz2000

    View of Select from (select ...)

    sorry, calender week is basically the week number. So The first week of the year is 1 and the last week in december is 52..or sometimes 53.. This was my cw1, cw2 and cw3 before..or maybe I called it a,b and c. Either way, I decided it would be better to structure the table this way.
  5. kingz2000

    View of Select from (select ...)

    Hi Guys, I have the next part of my riddle:) I have a table like this : with the select below I can obtain my desired result: select distinct artikelnr, calender_week, imputed_calender_week from ( select distinct artikelnr , datum , calender_week , first_value(menge) over...
  6. kingz2000

    select data with date condition, choosing latest values from selected dates

    Hi guys, yes you are completely right, I had a bad table structure. Sorry, I am learning. At first, I falsily had a,b, and c as columns although they are calender weeks, which would have meant 52 columns, which is obviously stupid. So I will have a column "Calender week", where I have the...
  7. kingz2000

    select data with date condition, choosing latest values from selected dates

    Hi Andrzejek, nulls can occur in a, b or c. In fact, a,b, and c are calender weeks which generally go on for 50 columns, say. Maybe an update , filling the nulls with last values, would be an adequate first step to simplify things? Basically, I don't mind if its several steps. To avoid...
  8. kingz2000

    select data with date condition, choosing latest values from selected dates

    ...so just to clarify, I would need a datum criteria where if I say datum between '2020-01-01' and '2020-01-03', then it should give me: 1 10 4 3 2 30 15 2 and if I give datum between '2020-01-03' and '2020-01-04', then it should give me: 1...
  9. kingz2000

    select data with date condition, choosing latest values from selected dates

    Hi guys, thanks ever so much for your input so far..so glad you'Re on the case...yes Andrzejek is right with what I need. Due to the selected date criteria, the first record needs to be omitted. So I guess, I need to be able to add a date condition at the end of it somehow.
  10. kingz2000

    select data with date condition, choosing latest values from selected dates

    do xou know what I mean? Shall I elaborate?
  11. kingz2000

    select data with date condition, choosing latest values from selected dates

    Hi, first of thanks for the prompt answer. For the artikelnr = 2, the first result should be a=30, because the "last" given value was 30 (a day before), then b=15 because on the 3rd of january there was a value of 15, and c hence 2. ) SO the thing is, if there are no data for that given last...
  12. kingz2000

    select data with date condition, choosing latest values from selected dates

    Hi everyone, I have the following table below: artikelnr dates a b c 1 01.01.2020 10 7 1 1 02.01.2020 null 5 2 1 03.01.2020 null 4 3 1 04.01.2020 null 9 4 2 01.01.2020 20 10 4 2 02.01.2020 30 20 3 2 03.01.2020 null 15 2 I would...
  13. kingz2000

    python list apply lamda

    Hi guys, I have a list with this command: categories.loc[0,:] which reads 0 related-1 1 request-0 2 offer-0 3 aid_related-0 Now I would like to append a Dataframe "categories" with these contents, except I don't want...
  14. kingz2000

    Hi guys, since its so quiet here

    yes, df is the general short term for any panda dataframe
  15. kingz2000

    Hi guys, since its so quiet here

    Hi guys, since its so quiet here ,let me throw in another easy one. The problem is, that I'm so used toSQL and using "Where"..So here goes.. df['artist'].value_counts().reset_index() gives me a select count... now how I can add a condition to only list those above a certain number, say 3? I...
See more

Part and Inventory Search

Back
Top