If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL Command
How do you total up figures within a column,Using SQL command?
I need the syntax |
#2
|
|||
|
|||
SELECT Sum([ColumnName]) FROM TableName
-- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Wantula" wrote in message ... How do you total up figures within a column,Using SQL command? I need the syntax |
#3
|
|||
|
|||
On Thu, 28 Oct 2004 07:45:02 -0700, "Wantula"
wrote: How do you total up figures within a column,Using SQL command? I need the syntax SELECT SUM([fieldname]) AS SumOfFieldname FROM [tablename]; John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with SQL Command | Word Problem | General Discussion | 2 | September 9th, 2004 04:43 AM |
SQL Command | KD | New Users | 1 | August 31st, 2004 03:18 PM |
Function isn't available in expressions in query expression | Reiner Harmgardt | General Discussion | 4 | July 21st, 2004 09:30 AM |
multiple sql statements in OLE DB command | Jerry Nettleton | Running & Setting Up Queries | 2 | June 18th, 2004 04:58 AM |
sql command | Jim Pomponio | Mailmerge | 1 | April 30th, 2004 06:39 PM |