Windows Vista 
Access 2010 32bit
2010 Excel and Access
I have a large Excel spread sheet with records that have columns where some have times added and others have miles added. The first two columns have customer names in them.
For example:
Column 2 Column 3 Miles between Travel time Mowing time
Harris to: Bass 5.3 0:13:00 0:45:00
Harris to: Blanton 6.1 0:15:30 1:20:00
Harris to: Crane 2.0 0:02:00 0:45:00
Hedlund to: Blanton 7.8 0:21:00 0:35:30
Hedlund to: Yordy 4.3 0:08:00 0:40:00
I use this to schedule my mowing route and to determine how long the day will take. So far I have done it all in Excel, copying and pasting to a separate worksheet for each day. On this worksheet all the calculating is done. This has worked okay but is very time consuming. I would like to see if I can import this into Access and somehow use a query or someway to start typing the name in column 2 then when it matches the name press enter and start typing the name in Column 3. Then once a match is found there hit enter and have that record moved somewhere that it can be listed with other records chosen for that day. Once the record is moved I would like the cursor to go back to looking for input to column 2 again repeating the process until all the lawns are chosen for the day.
The calculating would then be done where the records were moved. Such as:
From: To: Miles Tr. Time Mow Time
Harris to: Blanton 5.3 0:13:00 0:45:00
Blanton to: Anderson 2.1 0:05:00 1:10:00
Totals for Monday: 7.4 0:18:00 1:55:00
Any help would be greatly appreciated
Reply With Quote
