Modules

I have a query set up with time in seconds. I have manage in my wisdom to create a module to convert time into hh/mm/ss....how do i combine the two? If my query is called Time and the two columns are Time1 and Time2., the module is called Convert?

s

stella wrote:

I have a query set up with time in seconds. I have manage in my wisdom to create a module to convert time into hh/mm/ss....how do i combine the two? If my query is called Time and the two columns are Time1 and Time2., the module is called Convert?


Maybe it's just a terminology difference, but a module is
only a container for procedures, either Sub or Function.

A Public Function in a standard module can be called from
just about anywhere in Access, so your query could have a
calculates field:

Timehms: Convert([Time1])
--
Marsh
MVP [MS Access]