var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculating Time Taken
I dont actually think I sleep any more
I have a table with 2 fields time logged and time closed, these fields are setup so they contain a date format such as
I need to create a query where I extract all data where timetaken is less that 2hrs
When I use excel I can do time closed - time taken and set the format as hh:mm:ss and this will get rid of the actual date part, but i'm not sure what to do in access.
Again any suggestions would be great.
Can you create extra fields and have a formula in that???
Read this document...it may help.
Self Taught In ALL
Environments.....And It Shows!
datediff("h",[startdate],[stopdate]) will give you the difference in hours..
You may put in the criteria of <=2 in a query to pull your report.
You can replace the "h" with any of these:
y Day of year