looking between two times?

[jbarna]

I am new to access and i created a db that tracks production time. my
problem is that i have a form with a start time and end time and i
need to write vba code to look between the start time and end time to
see if there is a predefined lunch and break time and subtract it
from the total time.


can any one help me!

 

[Roger Carlson]

Are you storing the times as date/time fields or as text fields?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[jbarna]

Are you storing the times as date/timefields or as text fields?

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L







- Show quoted text -

actualy they are unbound text boxes in a form used to calculate total
time for a job then use that time to calculate Efficiency, setups,
I have all that worked out i just want to write code to automaticly
deduct lunch and break times if they fall between the start time and
end time.