Converting Seconds to H M S in a report?

[Sailor]

Howdy,



Please bear with me, as I know this must be a REALLY simple thing to do. I have a field in my table to store a time in seconds. In my report, I want the field to be displayed as Hours.Minutes.Seconds. I have been searching, and understand the basic calculation as below (and this is what I used to do in Excel). I just don't know specifically WHERE the formula is applied. Do I have to create a new table column in the db? I don't really want to store the value...just display the more user friendly version in a report.

Format([Hold]/86400, "hh:mm:ss")

If someone is willing to show me where this goes, it would be appreciated!

[CJ_London]

if it is a calculated value (as opposed to a value you want in a table instead of the number of seconds), you just use it in a query, form or report as required - the formula you have looks OK as is)

[Sailor]

if it is a calculated value (as opposed to a value you want in a table instead of the number of seconds), you just use it in a query, form or report as required - the formula you have looks OK as is)

Thanks for the quick response...I need baby steps here....

My report is bound to a query, which does report the "Hold" field, which is in seconds. On the report, I want the field to display the H M S instead. Do I leave the current "Hold" field on the report, and somehow apply this formula and format?

[CJ_London]

I would put it in the query something like

hmsHold:Format([Hold]/86400, "hh:mm:ss")


and use hmsHold on your report. If you are not using Hold for anything else on your report, then no need to bring it through in query since you are using hmsHold instead

[Sailor]

OK, Now I've got it! Thanks Ajax.