I'm trying to write a text file that includes a count of each type of movement in 15 minute increments. The output will look similar to this...
06/22/1988,07:00,1,0,5,6,7...
06/22/1988,07:15,3,5,0,0,5...
06/22/1988,07:30,1,5,0,0,9...
I understand how to write to a text file, but I'm not sure of the best way to organize my data. I have an inventory table that has each movement recorded with a timestamp. I thought I could get this to work with "Select Count(Movement) from inventory" query, but the way I have it now, I would have to write a query for every possible combination for each time increment.There are 52 possible movements and 44 time units.
Any suggestions?
Thanks.
06/22/1988,07:00,1,0,5,6,7...
06/22/1988,07:15,3,5,0,0,5...
06/22/1988,07:30,1,5,0,0,9...
I understand how to write to a text file, but I'm not sure of the best way to organize my data. I have an inventory table that has each movement recorded with a timestamp. I thought I could get this to work with "Select Count(Movement) from inventory" query, but the way I have it now, I would have to write a query for every possible combination for each time increment.There are 52 possible movements and 44 time units.
Any suggestions?
Thanks.
