Query for minutes

[wbabbit]

I wrote a little app that finds how long the duration of a phone call
was when the user enters the start and end time of the phone call. My
question is how do I query the results of this? It's stored in the
database as 00:11, 00:15, etc, but it won't let me query as >10,

00:10, etc. I just need to be able to pull all the calls that are more

than 10 minutes. Ideas?

[Ed Robichaud]

You'll need to change the formatting of your time field, as what happens
when a call is 125 minutes long? That should allow you to query on integer
values.

BTW, it's usually not a good idea to store calculations. You can use
DateDiff("n",[starttime],[endtime]) to calculate the call time in minutes
anytime you need to show it in forms/reports.

-Ed

<wb*****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I wrote a little app that finds how long the duration of a phone call
was when the user enters the start and end time of the phone call. My
question is how do I query the results of this? It's stored in the
database as 00:11, 00:15, etc, but it won't let me query as >10,

00:10, etc. I just need to be able to pull all the calls that are more

than 10 minutes. Ideas?

[Allen Browne]

You have a pair of Date/Time fields in your table?

You could create a query into this table, and type something like this into
a fresh column of the Field row to show the duration of the call in whole
minutes:
Minutes: DateDiff("n", [Start Time], [End Time])
You can then use the Criteria row under this calculated field.

More information:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<wb*****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I wrote a little app that finds how long the duration of a phone call
was when the user enters the start and end time of the phone call. My
question is how do I query the results of this? It's stored in the
database as 00:11, 00:15, etc, but it won't let me query as >10,

00:10, etc. I just need to be able to pull all the calls that are more

than 10 minutes. Ideas?