Search results

I've written an expression within a query to do a time/date calculation and report the result with a bunch of other data I've pulled. The expression works great and does exactly what I ask of it. However, my superiors would like the data returned in a slightly different format. My expression is...

Hi All, Let me preface this with I don't even know if this is possible... I am needing a query to calculate elapsed time in business hours for each record selected (I normally base this on a date range). For the purposes of this query, business hours are defined as Mon-Fri from 7 AM until 9...

Hi, I'm new to Access (like thousands of others here :banghead:) and am having an issue with Access not liking to display elapsed time over 24 hours correctly. My original expression for this field was [Outage End] - [Outage Start]. I kept the result type as Date/Time but used a custom Format...