access adding value from different table to one

[lokeshsu]

Hi i have around 10 table and i have start time and end time i need a query in access where it should take difference of start time and end time and sum up to a single number

for example
table 1 end time-start time = a
table 2 end time-start time =b
table 3 end time-start time =c
table 4 end time-start time =d
table 5 end time-start time =e

so i need the sum ( a+b+c+d+e )

 

[Trevor G]

Take a look at this and see if it helps: Adjust the format to the Sum to Hours and Minutes.

Excel Workbook
	F	G	H	I	J
1	Start Time		End Time		Total
2	08:30		16:42		08:12
3	09:12		13:12		04:00
4	08:31		17:03		08:32
5	09:00		16:12		07:12
6
7
8
9				Total Time	27:56
Sheet1

 

[lokeshsu]

I know the formula in excel bu i need it in access

 

[Trevor G]

Create a query where you are using start time and end time then save the query then you can add an expression which is the same as Excel except you are using field names.

Use DateDiff something like this, you can look up DateDiff for the different ways to dispaly your answer

Expr4: DateDiff("n",[starttime],[endtime])