Sum Job Time Column

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
 
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")
 
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


Adam said:
I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
 
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


Adam said:
I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
Apparently [Job Time] is a text field and therefore the error in trying to
sum. You need to bring a number forward to sum.
--
KARL DEWEY
Build a little - Test a little


Adam said:
I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


:

Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
Try
=Sum(Val([JobTime]))

Evi

Adam said:
I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


:

Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top