Search results for query: *

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

thanks dude

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

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.

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

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

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

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

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.

do xou know what I mean? Shall I elaborate?

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

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

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

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

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

Hi, just an easy question here from a beginner:) How do I find out the value_count of X which has a condition? For example df['Drinks'].contains("diet").value_counts() Thanks in advance

Thanks Andrzejek..It worked perfectly:)

Hi Guys, I need your help regarding Tables in Database, in general. Its been a while since I was here, and had a Database problem since I haven'*t been working with DBs at all..So bear wih me:) I have a table structured with the columns Contract, Section, Amount 2014, Amount 2015, Amount 2016...

Hi Every1, In MS Access, is there a way of creating an SQL to show data in a table which isn't in another? For example, Table A has one column called "Digits". Table B has the same column. In Table A the Datasets in "Digits" reads {1,3,6,7,8} In Table B the datasets in "Digits" reads...

thanx! I actually tried an index=0 but didn't think it would start with 1:-) thanx a lot.