|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
February 26th, 2004, 12:45 PM
|
|||
|
|||
|
Summarizing Records
Hi all -
I have a reporting page which reports information on one order number. Anyways, there are about 45 records for the 1 order number detailing numbers and dollars and such. Is there any way through SQL to just display the 1 order number with only 1 record ? this would require adding up all the number fields and putting the total into one row to be displayed so the user doesnt get 45 rows of the specific information. Here is my basic SQL statement: "SELECT YKPC_EXT_Orders.ACCOUNTANT, YKPC_EXT_Orders.FULL_NAME, YKPC_EXT_Orders.CL, YKPC_EXT_Orders.RF, YKPC_EXT_Orders.RFGL, YKPC_EXT_Orders.SITE, YKPC_EXT_Orders.PL, YKPC_EXT_Orders.[ACTUAL AMOUNT], YKPC_EXT_Orders.[TARGET AMOUNT], YKPC_EXT_Orders.[PRICE VAR], YKPC_EXT_Orders.[MATL USAGE], YKPC_EXT_Orders.[OTHER USAGE], YKPC_EXT_Orders.[PROCESS CHG VAR], YKPC_EXT_Orders.[VOL VAR] FROM YKPC_EXT_Orders WHERE YKPC_EXT_Orders.RF = 2 thanks Last edited by layz d : February 26th, 2004 at 01:05 PM.
|
|
#2
February 27th, 2004, 02:54 PM
|
|||
|
|||
|
use Group by
use group by command
|
|
#3
March 1st, 2004, 10:29 AM
|
|||
|
|||
|
Ok If i want every record summarized then i go like this??
"SELECT YKPC_EXT_Orders.ACCOUNTANT, YKPC_EXT_Orders.FULL_NAME, YKPC_EXT_Orders.CL, YKPC_EXT_Orders.RF, YKPC_EXT_Orders.RFGL, YKPC_EXT_Orders.SITE, YKPC_EXT_Orders.PL, YKPC_EXT_Orders.[ACTUAL AMOUNT], YKPC_EXT_Orders.[TARGET AMOUNT], YKPC_EXT_Orders.[PRICE VAR], YKPC_EXT_Orders.[MATL USAGE], YKPC_EXT_Orders.[OTHER USAGE], YKPC_EXT_Orders.[PROCESS CHG VAR], YKPC_EXT_Orders.[VOL VAR] GROUP BY YKPC_EXT_Orders.ACCOUNTANT, YKPC_EXT_Orders.FULL_NAME, YKPC_EXT_Orders.CL, YKPC_EXT_Orders.RF, YKPC_EXT_Orders.RFGL, YKPC_EXT_Orders.SITE, YKPC_EXT_Orders.PL, YKPC_EXT_Orders.[ACTUAL AMOUNT], YKPC_EXT_Orders.[TARGET AMOUNT], YKPC_EXT_Orders.[PRICE VAR], YKPC_EXT_Orders.[MATL USAGE], YKPC_EXT_Orders.[OTHER USAGE], YKPC_EXT_Orders.[PROCESS CHG VAR], YKPC_EXT_Orders.[VOL VAR] FROM YKPC_EXT_Orders WHERE YKPC_EXT_Orders.RF = 2
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Summarizing Records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
