call times greater than 16:08

[vicky]

Hi
I need to create a query with call times greater than 16:08 for "Time
Notified" and "Time Arrived to Scene" fields. What formula would I use for
that?
Thanks

 

[Dirk Goldgar]

Hi
I need to create a query with call times greater than 16:08 for "Time
Notified" and "Time Arrived to Scene" fields. What formula would I
use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is greater
than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?

 

[vicky]

Sorry for being unclear
1. Yes, I mean i want the query to return all records where the interval
between [Time Notified] and [Time Arrived to Scene] is greater than 16:08
2. Yes, both of them are the names of data/time fields in the table in this
format "m/d/yyyy hh:mm:ss am/pm"
3. When i say 16:08 I mean minutes and seconds

Hi
I need to create a query with call times greater than 16:08 for "Time
Notified" and "Time Arrived to Scene" fields. What formula would I
use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is greater
than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Sorry for being unclear
1. Yes, I mean i want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08
2. Yes, both of them are the names of data/time fields in the table
in this format "m/d/yyyy hh:mm:ss am/pm"
3. When i say 16:08 I mean minutes and seconds

Hi
I need to create a query with call times greater than 16:08 for
"Time Notified" and "Time Arrived to Scene" fields. What formula
would I use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?

Okay, then create a calculated field in your query like this:

ResponseTime: DateDiff("s", [Time Notified], [Time Arrived to
Scene])

That will return the difference in seconds between the two times. Then

968

That will return all records where the number of seconds between the two
times is greater than 968, which is (16 minures * 60 seconds/minute) + 8
seconds.

 

[vicky]

Thanks a lot, that worked
what if i wanted to know the difference in minutes between the same two
fields instead of seconds?
I know I have to switch "s" to "n" in my calculated field but what about the
criteria part?

Sorry for being unclear
1. Yes, I mean i want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08
2. Yes, both of them are the names of data/time fields in the table
in this format "m/d/yyyy hh:mm:ss am/pm"
3. When i say 16:08 I mean minutes and seconds

Hi
I need to create a query with call times greater than 16:08 for
"Time Notified" and "Time Arrived to Scene" fields. What formula
would I use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?

Okay, then create a calculated field in your query like this:

ResponseTime: DateDiff("s", [Time Notified], [Time Arrived to
Scene])

That will return the difference in seconds between the two times. Then

968

That will return all records where the number of seconds between the two
times is greater than 968, which is (16 minures * 60 seconds/minute) + 8
seconds.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[vicky]

Sorry I forgot to mention
16:08 is in hours and minutes now
thanks

Sorry for being unclear
1. Yes, I mean i want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08
2. Yes, both of them are the names of data/time fields in the table
in this format "m/d/yyyy hh:mm:ss am/pm"
3. When i say 16:08 I mean minutes and seconds

Hi
I need to create a query with call times greater than 16:08 for
"Time Notified" and "Time Arrived to Scene" fields. What formula
would I use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?

Okay, then create a calculated field in your query like this:

ResponseTime: DateDiff("s", [Time Notified], [Time Arrived to
Scene])

That will return the difference in seconds between the two times. Then

968

That will return all records where the number of seconds between the two
times is greater than 968, which is (16 minures * 60 seconds/minute) + 8
seconds.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[vicky]

Ok so now you can ignore my two last posts, I figured it out
Thanks a lot for your help again

Sorry I forgot to mention
16:08 is in hours and minutes now
thanks

Sorry for being unclear
1. Yes, I mean i want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08
2. Yes, both of them are the names of data/time fields in the table
in this format "m/d/yyyy hh:mm:ss am/pm"
3. When i say 16:08 I mean minutes and seconds


:

Hi
I need to create a query with call times greater than 16:08 for
"Time Notified" and "Time Arrived to Scene" fields. What formula
would I use for that?

I have some questions:

1. Do you mean you want the query to return all records where the
interval between [Time Notified] and [Time Arrived to Scene] is
greater than 16:08?

2. Are [Time Notified] and [Time Arrived to Scene] the names of
date/time fields in the table?

3. When you say "16:08", is that hours:minutes, or minutes:seconds?

Okay, then create a calculated field in your query like this:

ResponseTime: DateDiff("s", [Time Notified], [Time Arrived to
Scene])

That will return the difference in seconds between the two times. Then

968

That will return all records where the number of seconds between the two
times is greater than 968, which is (16 minures * 60 seconds/minute) + 8
seconds.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Ok so now you can ignore my two last posts, I figured it out

LOL When I saw the sequence of messages, I guessed that you had.

Thanks a lot for your help again

You're welcome.