I have a report that shows teach ti

[puforee]

I have a report that shows teach time valuces in the detail portion of the screen. The teaching time for each subject is in the format of Short Time. So it would look like this as an example...7:30.

In the report Header I inserted a Text box with the Control Source =Sum([Teach Time]). I set the Format of the Text box control to Short Time.

I am not getting the correct total for all the teach times shown on the Detail screen.

What am I doing wrong?

 

[MajP]

Is TeachTime a calculated control? If so:

http://support.microsoft.com/kb/113354

 

[puforee]

No...It comes is from a Table.

Any thoughts?

 

[puforee]

MajP,

I recreated the report with the Report wizard. When I select Summary items it did not show Teach Time. Evidently the format is not recognized as a mathematical fields. So...in the Reports underlying query I calculated two new fields Hours:Hour([Teach Time]) and Minutes:Minutes([Teach Time])

These fields worked and when the Report Wizard was run, they were recognized as Summary items.

Now all I have to do is convert the minutes to hours and minutes and add the conversion hours to the hours field. That way minutes will always be less than 60.

I think this will be easy.

Anyway, thanks for listening...have a good day.

 

[dhookom]

What you are doing wrong is displaying a point in time format for a duration of time. I would expect you to display the number of hours and/or minutes.

Duane
Hook'D on Access
MS Access MVP