Search results

I have a query that calculates the elapsed time between [StartTime] and [EndTime], both stored as text in the 24 hour/military time format. This is what I am currently using but it only returns a whole number, such as 1 or 2, but ignores the minutes, so if it should be 1:30 (1.5) is just shows...

I am looking to setup a query that will run on the previous month's data, the db has dates stored in the yyyymmdd format, which is what I believe is causing issues with any criteria I have tried to use. It will be pulling from a table called "Attendance" and a Field called "AssignDate". Thank you!