: how can I sum stopwatch time

[June7]

Modify [Table1 Query Query] to do Count and Avg aggregation.



SELECT Sum([Table1 Query].TotalSecs) AS SumSecs, Count([Table1 Query].[TotalSecs]) AS CountRecs, Avg([TotalSecs]) AS AvgSecs FROM [Table1 Query];

I expect your actual data will have some fields for a ParticipantID or TrialID and the aggregate query will need a GROUP BY clause. How these queries should be modified depends on your actual data structure. Do some research on building aggregate queries.

[msamir12]

@june7
Thanks a lot for your response but I assume that I have exprements each one has a time and I have for example 20 trials each trial has a time this is the sum of the time in the QUERY but I need to know the average handling time like that (total time / total trials) that means I need the calculation of (total time/20) in this DB the total time comes from the QUERY and the total of trials is the ID (auto count - primary key) I need to make this equation to have this "Average" like this equation
Please If you or any one can help with that I know you can and I need it badly ... thanks a lot

[June7]

I don't understand. What do you mean by the total of trials is the ID? Post example raw data and example of desired output.

[msamir12]

Guys thanks a lot for all of you I have the pleasure to join such community it is very useful and helpful forum I already made very good things and remembered some of what I forgot before

Thank You guys