Help on Sum

[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

 

[KARL DEWEY]

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