Using MS Access/Tracking Zip Codes


I am volunteering for a non-profit organization. We currently ask visitors for their zip code so we can track where they come from to evaluate our advertising. I have written a quick database to collect the information so we can manipulate it, but it is cumbersome. Eventually I will query the database for all zips in a geographic/city location for a range of dates to see if our advertising is working. I currently add the date and zip code for each visitor. What I want to do is enter the date once and then enter all the zip codes for that day. There has to be a better solution than what I am doing now. Thanks for any help you can give me.

You could make a CONTINUOUS FORM, enter the date in an unbound text box in the FORM HEADER and then make the DEFAULT VALUE for the date field in the detail section equal to the name of the form header field.

Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Richard Rost
599CD Computer Training

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Richard Rost


I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.


I am the president of and I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at

©2017 All rights reserved.