Show number of customers per zip code on a map (1 Viewer)

Local time
Today, 01:05
Joined
Apr 25, 2019
Messages
62
Is it possible in Access to create a Form or Report that will show a map (like Google Maps) that shows our 4 Retail Store Locations and then all the Zip Codes around the store and the number of Customers that have addresses in each Zip Code? This may be too complicated for Access? thanks!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:05
Joined
Oct 29, 2018
Messages
21,581
Just thinking out loud, but I don't see why not by using REST API through Google or Bing Maps. Have you looked into that?
 
Local time
Today, 01:05
Joined
Apr 25, 2019
Messages
62
I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:05
Joined
Oct 29, 2018
Messages
21,581
I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!
There have been some discussions here with regards to using REST APIs. Try to do a quick search. I'll see if I can find a link for you too.
 

mike60smart

Registered User.
Local time
Today, 07:05
Joined
Aug 6, 2017
Messages
1,917
I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!
Colin Riddington (Mendip Data Systems), Access MVP 2022-2023, Website is probably your best point of contact as he has
covered this extensively.
 

isladogs

MVP / VIP
Local time
Today, 07:05
Joined
Jan 14, 2017
Messages
18,269
This should be easy to do as long as you know the geo-coordinates of each zip code.
You would then add a marker layer at each zip code position with the number of customers
The only problem is that each marker can only have a single character so you may need to show a table with the number alongside the map.

See my article
 

moke123

AWF VIP
Local time
Today, 02:05
Joined
Jan 11, 2013
Messages
3,952
If your in the U.S., check the U.S.P.S. website. They have a bunch of API's.


 
Last edited:

Users who are viewing this thread

Top Bottom