How to give group by in the select query

[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

 

[[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[subbu]

Hi,
How to give the same as query criteria in Select query

subbu