Addition according to ID

[adhossain]

Hi, I've a access table like below





I want to make a query which will first findout the duration of time by "Starting-Ending" and then add the result according to ID. For example below

[Bob Fitz]

This may get you started.
Create the following query:

SELECT tblTable.ID, (DateDiff("n",[t1],[t2]))/60 AS difFROM tblTable
GROUP BY tblTable.ID, tblTable.t1, tblTable.t2;

Then create the following query:

SELECT FirstQry.ID, Sum(FirstQry.dif) AS durationFROM FirstQry
GROUP BY FirstQry.ID;

The second query should give the required result but is not formatted to show result as 00:00
Also, pretty sure this could be done in one query using the first query a sub query within the second but that is not my strong suit.

[adhossain]

This may get you started.
Create the following query:

SELECT tblTable.ID, (DateDiff("n",[t1],[t2]))/60 AS difFROM tblTable
GROUP BY tblTable.ID, tblTable.t1, tblTable.t2;

Then create the following query:

SELECT FirstQry.ID, Sum(FirstQry.dif) AS durationFROM FirstQry
GROUP BY FirstQry.ID;

The second query should give the required result but is not formatted to show result as 00:00
Also, pretty sure this could be done in one query using the first query a sub query within the second but that is not my strong suit.

Hi Bob,
Thank u very much for ur kind information. I may come to u again for finding solution

[Bob Fitz]

Thank u very much for ur kind information. I may come to u again for finding solution

Please do. We are always glad to help if we can.

[adhossain]

Please do. We are always glad to help if we can.

Hi Bob,
I'm really novice in MS Access. I'm attaching here my database. I have putted some text boxes and labels in the Report. I need to figure out those information like total training, total time, total participants, sex ratio (Please see attachment).
But the report needs to be produced according to the time period of "tblTime.Date" and "lstTimePeriod" of report named "rptMain"
I know it might not possible for u to provide in depth solution of this. But it would be really helpful for me if u could guide me on this.

M&E_DB.mdbM&E_DB.mdb

[Bob Fitz]

Well to start with your report has no Record Source