subform calculation

[Guest]

I have a subform (continuous) that receives the info thru a query. In the
query is an added field for providing the amt of time in a given time period.
This works fine and provides the info in a short time format. What I am
wanting to do is to have the subform display the total time for the selected
project. I have a textbox in the footer of the continuous subform but I keep
getting an #error in the textbox. Here is the query info;

SELECT tblProjectWorkTime.ProjectWorkTimeID,
tblProject.ProjectName,
tblProjectWorkTime.ProjectWorkTimeDate,
tblProjectWorkTime.ProjectWorkStartTime,
tblProjectWorkTime.ProjectWorkEndTime,
tblProjectWorkTime.ProjectWorkTimeDescription,
tblProject.ProjectID,
tblProjectWorkTime.ProjectWorkTimeArchived,
Format([ProjectWorkStartTime]-1-[ProjectWorkEndTime],"Short Time") AS
RecordAmount

FROM tblProject INNER JOIN tblProjectWorkTime ON tblProject.ProjectID =
tblProjectWorkTime.ProjectID

WHERE (((tblProject.ProjectID)=[Forms]![frmProject]![txtProjectID]) AND
((tblProjectWorkTime.ProjectWorkTimeArchived)=No))

ORDER BY tblProjectWorkTime.ProjectWorkTimeDate DESC;

The textbox on the subform (RecordAmount) shows the record level amt fine.
It is the (ProjectAmount) text box in the footer that is giving me a headache.

Can anyone see what is needed (besides aspirin) to get this to work?

Thanks in advance to anyone responsding.

*** John

 

[Allen Browne]

The Format() function geneates text, and you cannot sum text.

Use DateDiff() to calculate the difference in minutes. Details in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html