Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / October 2008

Tip: Looking for answers? Try searching our database.

Time Calculation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PHisaw - 09 Oct 2008 22:37 GMT
Hi,

I have a field that has total time spent on job and now boss wants a
"countdown" of time left to finish job. If I have a number type field for
hours given to complete job, how can I work a calculation to subtract the
time spent (which is a date/time field) from the hours given so that each
time a tech signs on to said job the time left to complete job appears in
field?

Any help is greatly appreciated.
Thanks,
Phisaw
Lord Kelvan - 09 Oct 2008 23:58 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.