Member Avatar
I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) `SELECT COUNT(Software) AS ActualQty FROM tblswlogs WHERE Software='MS EXCEL'` and (**Total** will appear in textbox) `SELECT MAX(used + initialqty) As Total FROM tblswlist WHERE Software = …
by kayecng in Databases ()
Member Avatar
Cell C4 has the expression =565+660+709+1093 Is there a function/nest of functions that can output the number of values being added? BIG NOTE: I AM NOT ASKING FOR THE SUM OF THE EXPRESSION!
by Stagnant in Microsoft Windows ()
Member Avatar
Hi everyone i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this SELECT SUM(total) as branch1sales FROM icm.sales UNION SELECT sum(total) as branch2sales FROM hism.sales its …
by ehpratah 48 in Databases ()
Member Avatar
I'm sure this is simple, but I'm having a time trying to figure out how to add two fields from two different tables together. <?php include_once('conn/db.php'); $query = "SELECT SUM(`sold`) AS total FROM veggies"; $stmt = $con->prepare( $query ); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row); echo "<small><u>Plants Sold</u>: {$total}</small>"; } …
by JayGeePee in Databases ()
Member Avatar
Good day guys, I would just like to share my code and wanted to do something about it. This code shows a loop inside a loop initializing a two-dimensional array named arr with elements [2] and [5]. Here's my code: #include <iostream> #include <conio.h> using namespace std; int main () …
by exoruel in Software Development ()
Member Avatar
Hey there, I'm having trouble getting my program to read every instruction to then execute it, as well as displaying everything correctly. Right now my program displays mainly garbage and for now I simply want it to be able to successfully run a simple addition program, so any advice or …
by crodriguez08 in Software Development ()
Member Avatar
Hi, I want to Count the number of occurences of data in a table, then multiply it in a value from other table, After that I want to sum up the product of count and the value from other table, As of now, I cant count and then multiple but …
by ms061210 in Databases ()
Member Avatar
#include<stdio.h> #include<math.h> int main() { int n,nstart,nstop,nstep,i,j,zNumber; ` printf("Please enter a value of a positive integer nstart: "); scanf("%d",&nstart); printf("Please enter a value of a positive integer nstop: "); scanf("%d",&nstop); printf("Please enter a value of a positive integer nstep: "); scanf("%d",&nstep); printf("Number\t\tzNumber\n"); printf("------\t\t-------\n"); n=nstart; zNumber= double pow(double_n,double_i); while(i<=nstop){ zNumber = …
by cnsk90 in Software Development ()
Member Avatar
please help for query... i want sum (kns+kng) by name - [example](http://sqlfiddle.com/#!2/b5a7e6) the result should be: name|sum ----------- john - 36 bart - 16 steve - 53 jim - 10 tnx
by Paor in Databases ()
Member Avatar
Hi Guys , I couldnt dispay sum of a column of sqlite database in php . I tried the sql statement in database its working fine but not sure how to dispay the result in PHP . I belive i need to fetch it and then dispay any help will …
by titos97 in Web Development ()
Member Avatar
Hi, I am using jQuery function to calculate total of item price (label) multiply by quantity (textbox), this is working fine so far. Also, I added additional label for shipping which getting the data from rbl object, also working fine. The calculation I'm trying to get is sum of total+shipping, …
by ypdev2 in Web Development ()
Member Avatar
So I have the following MySQL query, which works fine: select year(created_at) as year, month(created_at) as month, day(created_at) as day, item_sdb_id, price_per_unit from (select l.item_sdb_id, l.list_price / l.quantity as price_per_unit, l.created_at from listings as l inner join purchases as p on l.purchase_id = p.id where l.item_sdb_id in (12345) and p.created_at …
by pce369 -3 in Databases ()
Member Avatar
C++ program to find sum of marks entered by 30 students using for loop or while loop/
by super.sam1 in Software Development ()
Member Avatar
I'm trying to display some records which meet some certain criteria. That works fine, but I also want to retrieve the total amount of orders. These are all located in the field 'Amount' from the Orders table. So if record 1 has got '22' in it's amount field, and record …
by Michael_18 in Databases ()
Member Avatar
i am getting result of average in int instead of float, tell me where i have made mistake. this is the code. #include<iostream> using namespace std; void getData (int a[], int s); int numbersSum (int a[], int s); float average (int sum, int size); int main() { int size=0; int …
by kamalashraf in Software Development ()
Member Avatar
Here is my array: $a = array( “1” => “3”, “1” => “2”, “2” => “1”, “1” => “2”, “2” => “2”, ); and my expected output is : 1 = 7 , 2 = 3 How can I do that in foreach?
by devianleong in Web Development ()
Member Avatar
i have this new problem i hope that im not a spam here in this site.but i have to do this bcoz i have no where else to go.sorry for my english hope u understand me.in the picture that i uploaded i have textbox1 and textbox2 their value comes from …
by EXTRA_RICE in Software Development ()
Member Avatar
I have the following code that is working but i need further functionality. The code shows the payments made and is based on two tables. The payments table that has the following fields mID, type (account type), dayentered(date when the money was donated) and the members table has the following …
by Octavian_1 in Web Development ()
Member Avatar
Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've been googling my way to victory for the most part. I'm struggling on probably a very simple problem. I'd like to Sum the contents of a column, if …
by Yuexuan in Databases ()
Member Avatar
I choose a program that can read data from a txt file. Now, I input two column from txt file and i want to substract first value of 2nd column to every value of 2nd column. finally I want the sum of substracted values. Can anyone please help me. Actually, …
by siddiquedu in Software Development ()
Member Avatar
I'm trying to sum all numeric fields individually. I won't always know the field names, otherwise I could manually construct the query `SELECT SUM(Field1) as Field1, SUM(Field2) as Field2...etc FROM myTable` Is there a way to construct this on the fly in mysql? I'm thinking there's probably a way to …
by grant.baker 10 in Databases ()
Member Avatar
I have a void function that takes data from an ifstream, reads the first value, (which is an ID #), and compares that value against the ID# info from an array of records. If it's invalid, the rest of the line is ignored. If it's valid, it adds the hours …
by robert.speciale in Software Development ()
Member Avatar
This code example shows how to create a dictionary with row,column indexed (r,c) key tuples from a typical list of lists 2D matrix. Also an example is shown of the ease of processing the resulting dictionary.
by vegaseat 1,720 in Software Development ()
Member Avatar
Okay so I have couple of questions about lists in vb.. Please be aware that it's all related to integers only no strings or others 1. How to sum values of a list? 2. How to sort values of list from highest to lowest? Also how would I display list …
by xHellghostx in Software Development ()
Member Avatar
Hi i'm having a trouble with this i got 3 textbox and i format it to Textbox1.Text = Format(Textbox1.Text, "Standard") Textbox2.Text = Format(Textbox2.Text, "Standard") Textbox3.Text = Format(Textbox3.Text, "Standard") which give something like this 1,230.00 2,500.00 1,245.00 and when i add it `Textbox4.text = Val(Textbox1.Text) + Val(Textbox2.Text) + Val(Textbox3.Text)` the result …
by ImZick in Software Development ()
Member Avatar
Hi Guys, I was trying to code in C for the following. You are given with 2 files, file1.txt and file2.txt. The contents of the file contain INTERGER values. Add the contents of the file and write them to another file file3.txt. My code is as follows #include <stdio.h> #include …
by Ladis 10 in Software Development ()
Member Avatar
Good Day, I have a text file in the .csv format. The file originates as a xlsx (excel) file type. The file looks something like the following. Name Number Lat Long Jan Feb Mar Apr Brockton 24-1670-06 38.145236 145.854921 0.15 0.62 1.25 2.14 Westby 24-7432-04 35.846125 132.743652 0.25 0.94 1.14 …
by rexmorgan in Software Development ()
Member Avatar
I have over 10 text files, each file has exactly 2671 floats e.g. 1.232124234 #line 1 2.324234323 #line 2 . . 1.324234234 # line 2671 I would like to the add together the floats on each line with the float on the corresponding line for each of the 10 files, …
by padton in Software Development ()
Member Avatar
I have one table with content of data with a Status (Yes/No). I want to get sum of total data where status is "yes"and put it into another table and sum of total data where status is "no" and put it into previous table in a different column to maintain …
by Sadhikary in Software Development ()
Member Avatar
I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly. Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013. In all above sheet : Part numbers mentioned in column "C2:C60000" Quantity in column "D2:D60000" …
by avk24 in Software Development ()