making table date/time

  • Thread starter Thread starter ardi
  • Start date Start date
A

ardi

Hi,

How to make/query for field date/time with interval 5 second, such:
1/1/1990 00:00
1/1/1990 00:05
1/1/1990 00:10

thanks
 
While there's probably a more elegant solution, it seems like a "brute
force" method would be to calculate what portion of a day 5 seconds
represents, then test your time intervals, adding that fractional part of a
day each time.

JOPO (just one person's opinion)

Regards

Jeff Boyce
<Office/Access MVP>
 
Hi,

How to make/query for field date/time with interval 5 second, such:
1/1/1990 00:00
1/1/1990 00:05
1/1/1990 00:10

thanks
Click to expand...

Please explain the context. Do you have such times stored in your
table, and you want to search for them? Do you want to create a table
with twenty years' worth of five-second intervals? do you want to take
a table with arbitrary date/time values and categorize it into
five-second blocks?


John W. Vinson[MVP]
 
Back
Top