Modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...


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])
 
Back
Top