Time and its math

[TheCleaner]

When using a form to create a new record, how would I tell that record to find a previous (name specific) record with the latest date and use its data for computing the info for this new record? Example: Field name is [name] with [start] and [end] times for thier shifts. Wanting it to calculate the time off (between shifts). In additon what would be a general expression to add, subtract etc. values to time? Example: "now()+ 12 hours" or " =[starttime] + 12 hours", giving me the actual time that it would be. Thank you for ANY help!

 

[MichaelRed]

The subject of Date/Time calculations is rampant within the MS Access Forums and the VB Forums. Please search these with the key words DateDiff and DateAdd. You are sure to find a plethora of approaches.

While looking for help, you MIGHT try using the built in help for Ms. Access, They have documented these specific methods fairly well, including some meaningful examples. After you know the syntax for the commands / methods, the examples you find in the Ms. Access and / or VB forums will make some more sense.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[TheCleaner]

Thankyou