Skip to content. | Skip to navigation

Personal tools
Log in
Sections
You are here: Home Database Microsoft Access

Microsoft Access

Documentation, links, and sample code for the database program we love to hate (and hate to love)
Query and Reporting Tips & Tricks
Please add your own knowledge here.
Zip Code-2-City DB
An Access .mdb file with all zip code to city matches in the US for 1999 (last year of available US Census data for this information). Includes latitude, longitude, city, state and mailing class for each zip code.
Truncated memo fields in a query
When you export a query that contains an expression that results in more than 255 characters, the expression is truncated in the exported file. Here's a workaround.
Document Actions

Comments (0)

« February 2012 »
February
MoTuWeThFrSaSu
12345
6789101112
13141516171819
20212223242526
272829