Help desperately needed

[tibbles]

After working on a clients website, he decided to challenge me... He has an access database that needs editing, but I've never used MS Access before.

Half the fields on his Customer Order form are redundant, and needed removing, which I have done. I am getting no error messages, so I assume that everything has gone according to plan.

HOWEVER... He also wants me to add an area at the bottom of the same form, that will show a list of all his agents within a 20 mile radius of a given postcode (ie, the customers).

Anyone know if this is possible, and if so, how?

 

[Soma_rich]

You takling spatial query their. Unless each customer has an attribute saying how far away they are from a postcode.

I would say it cant be done in Access, you would need a GIS like ArcGIS or MapInfo.
Or
Oracle Spatial.

 

[tibbles]

Thanks Soma_rich. I'm sure it's not what he wants to here, but it'll save me looking for something that doesn't exist.