Adding a calculated field

[tourless]

Hi Folks.

First time posting in/working with Access so please be gentle. I have built a query that contains a field called 'Time' (PROCESS2.Time). 'Time' is in seconds and I want it to be in hours, minutes, seconds... from ss to hh:mm:ss. I'm trying to do this by adding an expression field called minutes and setting the criteria as [Time]/60. It's not working.

What am I doing wrong and/or what are my options?

Any and all insight is always greatly appreciated.

 

[Micron]

try Format(([Field1]/86400),"hh:nn:ss")
If you're an Access newbie then I'd suggest some important reading. You're already off on the wrong foot by naming a field "Time". Your worst disadvantage is likely that you know Excel and will carry over that design mindset to your Access tables. At least, it's a common approach.

Help Creating Database of Resources Used for Specific Groups

I will preface this quesiton with A) I work in the K-12 education sector, and B) I have very limited knowledge of databases - BUT I do have a pretty strong knowledge of Microsoft Excel and some experience with Power Query. I know there is a lot of different resources regarding many of these...

www.mrexcel.com