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.