How to give group by in the select query

S

subbu

Hi,
I have the requirement to sum up the values for each
month.How to give the criteria for summation and group by

regds
subbu
 
M

[MVP] S. Clark

Select ID, Sum(Value) From TableName Group by ID

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error while inserting null data in Append Query 1
How to update Rows 1
How to update the table 1
How to give parameter query 1
Either BOF OR EOF is True Error 1
How to give specify dates as criteria in Select query 4
Group By error message 2
SUM in a UNION query 2

Top