sound like you dont like you boss comming up with NEW ideas
create a text box and then give it a rowsource of
"select hoursttocomplete - sum(timespent) from jobtable,workdonetable
where jobtable.jobid = workdonttable.jodtid"
hope this helps
Regards
Kelvan
Marshall Barton - 10 Oct 2008 05:03 GMT
>create a text box and then give it a rowsource of
Getting tired?
... textbox ... rowsource ...
or did I miss a new feature?
;-)

Signature
Marsh
MVP [MS Access]
PHisaw - 10 Oct 2008 15:07 GMT
Kelvan,
Thank you for replying, but I don't quite understand your solution. I have
a table tGeneralInfo with a number field "TotalRepairHours" where number of
hours required to complete job should be entered. I have another table
tWorkLog with date/time fields StartTime and StopTime which are on a form
fTimeSheet with DateDiff calculation to give time worked for each record. I
also have a field "SummedHoursMinutes" which gives total time worked for each
job. The form fTimeSheet is a subform on the form fGeneralInfo and is
related by job number.
This being said all calculates and links together as it should. I think the
problem is how to subtract "SummedHoursMinutes" which is a date/time field
from "TotalRepairHours" which is a number field.
If you can further explain how I can use your solution or have any other
ideas, I would appreciate it.
Thanks again,
Phisaw
> sound like you dont like you boss comming up with NEW ideas
>
[quoted text clipped - 7 lines]
> Regards
> Kelvan
PHisaw - 10 Oct 2008 17:09 GMT
I have solved the problem. Thanks for your time.
> sound like you dont like you boss comming up with NEW ideas
>
[quoted text clipped - 7 lines]
> Regards
> Kelvan
Lord Kelvan - 12 Oct 2008 21:10 GMT
what o sorry yeah long day on friday i been staring at list boxes all
day