Converting seconds into minutes within a query

Question

I have a data grid on my form that is populated using the following:

SELECT [Activity_Date], [Activity_duration_seconds] * FROM tblActivity

Is there any way that I can add an extra field onto this query that returns minutes?

Thank you.

Answer 1

You can compute whatever you want:

SELECT Column1, 
       Activity_duration_seconds, 
       Activity_duration_seconds / 60 AS Activity_duration_minutes 
FROM tblActivity