Calculated distances

Resolved · Low Priority · Version 2003

Fri 21 Aug 2009, 10:47 Delegate Mike said...

Mike has attended:
Access VBA course

Calculated distances

Hello,

Are you aware of any code that can calculate distances between 2 UK Post Codes? (using Google Maps or other online mapping sites possibly?)

Many thanks for your help.

MIKE

Fri 21 Aug 2009, 16:35 Trainer Jacob said...

RE: Calculated distances

Hi Mike

Good question! We are actually looking into this ourselves and there is quite a bit to consider:

Do you "buy in" 3rd party code to save time? if so is it fully tested, do you need to source post code references separately?
What is the code written in? (php, vb, etc)

You can do a search on google for "postcode distance calculator code" and get some relevant results.

We are still looking for a solution to fit our requirements, good luck with yours!

Regards

Jacob

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds