SQL Query, find difference in two times.

[Creaturemagic]

So for a School project I have to design a database for a cab company, and I wanted to make a query to calculate the time difference between when the customer calls and when the driver arrives. However both fields are date/time fields, and I am unsure of the SQL query to calculate this.

[pbaldy]

I've written a couple of taxi apps. If those are both fields in the same record, you can just use the DateDiff() function.

[Creaturemagic]

I've written a couple of taxi apps. If those are both fields in the same record, you can just use the DateDiff() function.

With Datediff() as far as I know I have to type the dates in, don't I?
I don't want to have to type each time in and make like 30+ queries, is there a way to make it automatically select the two matching times from each field and find the difference.
Maybe I can do that, I'm just unsure how?
Also, I just tried a normal Datediff, this one:
SELECT DATEDIFF (Minute, '10:57:00', '11:02:00')
Access 2007 told me "Minute" needed a parameter.

Thanks for any help

[pbaldy]

No, you can simply refer to the 2 fields. Check help for the proper syntax; you've got the SQL Server syntax there.

[Creaturemagic]

No, you can simply refer to the 2 fields. Check help for the proper syntax; you've got the SQL Server syntax there.

This is the right code:
SELECT [Driver_ID], DATEDIFF(minute, [Request_Time], [Start_Time]) AS [Time Taken in minutes]
FROM Jobs

Yet Access still says "Enter parameter value... Minute"
According to Microsoft my code is correct: http://msdn.microsoft.com/en-us/library/ms174630.aspx
But for some reason it does not work

[pbaldy]

You didn't notice that says SQL Server at the top? You want "n" there, with the quotes.

[Creaturemagic]

You didn't notice that says SQL Server at the top? You want "n" there, with the quotes.

Dude thanks so much! You're a genius!

[pbaldy]

No problemo. Welcome to the site by the way!