Help on Sum

  • Thread starter Thread starter Lalit
  • Start date Start date
L

Lalit

Hi,

I would like to add some fields (data) of the same column with reference to
the identical time,which is another column.In more detail : My query has two
column, one time in hh:mm:00 for and second coloun the some counts.I want to
add all counts (of same time) in third column. Please help on this.

Thanks:

Lalit
 
SELECT YourTimeField, Sum([YourCounts]) AS SumOfCoumnts
FROM YourTable
GROUP BY YourTimeField;
 
Back
Top