Hi
I am new to database making
Here is the structure of my database
(simple start -end time for workers)
Table “workh” contains
Name
Date
STime(start time)
ETime(end time)
Then I have Query which also calculates the work time (from the queried data from the table) using:
Hours: Format([STime]-[ETime],"Short Time")
Then I have a Report that lists all these activities from the query
“[Date] - [Name] - [STime] - [ETime] - [Hours]”
Now what I need to do is to add a line to the end of the page that has the sum of all the Working Hours
Which means, if one of the operators has worked 01:05 in one occasion, and 02:10 in another occasion, then I want to calculate 03:15 and add it to the end of the page
The first problem comes here, that I have no idea how to add these times, as they are not a simple number, and how is it possible to do calculations of these kind in the reports (How to get the [Hours] to add up).
Another problem is ,
I have a form which let us to choose the Operators name and “From” and “To” for the date, and will set these as the filter of the reports that it will opens
Basically the report that is opened is a result of a filter set in the form.
And now how is it possible to add the [Hours] of the filtered data and make a sum at the end.
I will be grateful for any help.
I am new to database making
Here is the structure of my database
(simple start -end time for workers)
Table “workh” contains
Name
Date
STime(start time)
ETime(end time)
Then I have Query which also calculates the work time (from the queried data from the table) using:
Hours: Format([STime]-[ETime],"Short Time")
Then I have a Report that lists all these activities from the query
“[Date] - [Name] - [STime] - [ETime] - [Hours]”
Now what I need to do is to add a line to the end of the page that has the sum of all the Working Hours
Which means, if one of the operators has worked 01:05 in one occasion, and 02:10 in another occasion, then I want to calculate 03:15 and add it to the end of the page
The first problem comes here, that I have no idea how to add these times, as they are not a simple number, and how is it possible to do calculations of these kind in the reports (How to get the [Hours] to add up).
Another problem is ,
I have a form which let us to choose the Operators name and “From” and “To” for the date, and will set these as the filter of the reports that it will opens
Basically the report that is opened is a result of a filter set in the form.
And now how is it possible to add the [Hours] of the filtered data and make a sum at the end.
I will be grateful for any help.
