I have the two attached databases and what I need to get done is create the information in the form into a table or query format. The parameters for each form are start segment, end segment, and timestamp.
The first attached file (11-3-05.zip) generates travel time from 5 minute intervals (12:00 am, 12:05 am, 12:10 am, etc.) from any one segment to any next segment. The segments in the file are roadway lengths along a particular roadway. There are 15 in all. The are 288 timestamps since 1440 minutes in a day broken into 5 minute intervals. After I specify what 2 segments I want to know the travel time to AND the timestamp, then this DB will step up the travel time to the next timestamp if the travel time gets over 5 minutes because you have already traveled for 5 minutes and you are now in the next timestamp if you are driving along this roadway. This is known as my actual travel time. (actual_tt)
The second DB (11-5-08-test.zip) is the same but instead of stepping up to the next timestamp as the first DB does this stays with whatever original timestamp was selected in the form. This is known as my posted travel time. (posted_tt)
So I need to combine these two into a query format where the finished query has the following field lists.
start segment l end segment l timestamp l actual_tt l posted_tt
The tricky thing I need is all combinations of all segments and at each timestamp, only going south though with segment 1 being the northen most segment and 15 being the southern most. I have the code attached to the buttons that steps up the travel time and doesn't step up the travel time, so really I just need probably another code that will combine all this in a query. Thank you for any assistance.
The first attached file (11-3-05.zip) generates travel time from 5 minute intervals (12:00 am, 12:05 am, 12:10 am, etc.) from any one segment to any next segment. The segments in the file are roadway lengths along a particular roadway. There are 15 in all. The are 288 timestamps since 1440 minutes in a day broken into 5 minute intervals. After I specify what 2 segments I want to know the travel time to AND the timestamp, then this DB will step up the travel time to the next timestamp if the travel time gets over 5 minutes because you have already traveled for 5 minutes and you are now in the next timestamp if you are driving along this roadway. This is known as my actual travel time. (actual_tt)
The second DB (11-5-08-test.zip) is the same but instead of stepping up to the next timestamp as the first DB does this stays with whatever original timestamp was selected in the form. This is known as my posted travel time. (posted_tt)
So I need to combine these two into a query format where the finished query has the following field lists.
start segment l end segment l timestamp l actual_tt l posted_tt
The tricky thing I need is all combinations of all segments and at each timestamp, only going south though with segment 1 being the northen most segment and 15 being the southern most. I have the code attached to the buttons that steps up the travel time and doesn't step up the travel time, so really I just need probably another code that will combine all this in a query. Thank you for any assistance.
Last edited: