Hi,
I would like to start by saying I'm a novice and probably in over my head. I have an Access database with 1.5 million records. They depict the time and distance between two postcode sectors, as shown below.
From To Time Distance
BR1 1 BR1 2 5.3 2.9
BR1 1 BR1 3 4.1 1.7
BR1 1 BR1 4 4.2 2.2
I want to be able to enter the starting postcode sector and closing postcode sector in excel and have the journey time come up in excel - as though running a query. But this needs to be repeatable, so were I to enter another journey below the 1st one, the same thing happens.
I'm not sure how to go about doing this and would appreciate any advice!
Ross