how to generate a time axis with a quey

  • Thread starter Thread starter john
  • Start date Start date
J

john

Hi all,

I want to make a query that will display all the minutes between two hours,

i.e.

The initial data are 2 different hours, let say 07:50 and 08:01

the final result should be
07:50
07:51
07:52
07:53
07:54
07:55
07:56
07:57
07:58
07:59
08:00
08:01

I want to use that as a time axis for a dynamic graph

regards,
Pierre
 
Create a table with a field named CountNUM containing number from 0 (zero) to
your anticipated highest spread.

SELECT DateAdd("n",[CountNUM],CVDate([Enter beginning time])) AS Minutes
FROM CountNumber
WHERE (((DateAdd("n",[CountNUM],CVDate([Enter beginning time]))) Between
CVDate([Enter beginning time]) And CVDate([Enter ending time])));
 
Back
Top