How to calculate number of minutes between two DateTime in a query?

Assuming MS Access has the function DATEDIFF

SELECT DateDiff( mi, <STARTDATE>, <ENDDATE>) AS MinutesBetween

hi, mike
looks like youre few seconds later:)
ziolko.

I guess it should be :
SELECT DateDiff( "n", <STARTDATE>, <ENDDATE>) AS MinutesBetween

instead of

SELECT DateDiff( mi, <STARTDATE>, <ENDDATE>) AS MinutesBetween

Best regrads,

The Mayor

And use :

For Hours    : SELECT DateDiff( "h", <STARTDATE>, <ENDDATE>) AS HoursBetween
For Minutes : SELECT DateDiff( "n", <STARTDATE>, <ENDDATE>) AS MinutesBetween
For seconds : SELECT DateDiff( "s", <STARTDATE>, <ENDDATE>) AS SecondsBetween

See http://www.access-programmers.co.uk/forums/showthread.php?t=14680

Yeah looks like we posted seconds apart Ziolko   :o)

Thank you both very much for the solution.
I never knew that you can use the "as"-value within the statement.

Regards,
Stef

Glad to be of some help.
And thanks for the points and the grade.

Best regards,

The Mayor.