how to generate a time axis with a quey

[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

 

[Guest]

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])));