Charting Timestamps - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Charting Timestamps

Austin Ritner

5 years ago

For my dispatching database, I need to see how many calls took longer than a certain amount of time to arrive on scene once they were enroute. Example: Response time should be no longer than 7 minutes.

But of course there will be some that take longer than 7 minutes, and some shorter than that.

My brain has decided no work-y today LOL, so how do I differentiate between the two types of information?

	Alex Hedley @Reply 5 years ago
You could create an extra calculated column that works out the difference between the two times, then add conditional formatting to show if it's greater than or less than 7

	Austin Ritner OP @Reply 5 years ago
A-ha! Made a query from a query (which still confuses me slightly haha) and made that new field ResponseTime: EnrScene criteria being "00:07:00" and it worked!

	Richard Rost @Reply 5 years ago
Great! See this too: Duration

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View