jal I figured out the line of code that I need to delete from the code in my DB it was:
miscRS.Filter = "segTimeStamp = #" & currTime & "# AND segment >" & currSegment
But i have a new problem that maybe you can help with and I tried to explain it the best way I could so here it goes
I have average travel times over certain roadways segments in a road network (segments 1-15 in my DB). The travel times are averaged over five minute intervals (the average travel time for segment x from 12:00 am-12:05 am, for 12:05 am-12:10 am, etc.) throughout the day from raw speed data that I have access to. So in my DB I have the average travel time over every five minute interval throughout the day for every segment.
The next part, which is the topic of my project, is the total travel time. So when I want to find total travel time from segment x to segment y then I must add all the travel times between those two segment to get total travel time. But the catch is, for example, if the total travel time is more than five minutes from segment x to segment y I have to know at what segment BECAUSE once the total travel time is over 5 minutes then i must now use the travel times associated with the next timestamp or five minute interval because the travel times associated with the previous five minute interval are useless since I already have a travel time of 5 miuntes. This is the stepping up of travel times I mentioned in the first post and this is called my actual travel time.
The posted travel time is the same as the above explanation but once the total travel time is over five minutes then it doesn't move to the next five minute interval.
Now I have this information in the two forms attached. But what I would like to do is have this information side by side in a query or table so that I can compare it, the actual and posted travel time, that is.
It will probably involve joining two tables but first I need to get the information from the form into a table so I can join them, but that is the part where I am stuck.
I'm hoping that I can just use the code that I have attached to the command button in the form to the VB editor but then I need to define it in the fieldlist section of the query and am not sure how to do that either.
An example of what I am looking for from the table will be, Every combination of segment to segment at every five minute interval.
Example: So total travel time from segment 1 to segment 2,3,4,5,6,7,8,9,10,11,12,13,14,15 at every 5 minute interval throughout the day (12:00 am, 12:05 am, 12:10 am, etc.)
Then total travel time from segment 2 to segment 3,4,5,6,7,8,9,10,11,12,13,14,15 at every 5 minute interval
etc. for posted and actual travel time for comparison
I hope that helped and thank you for the reply back, please let me know if explanation is not clear enough. Thank you