Discussion Locked

Access 2002 - Mailing Labels

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is what happens when a techie-dabler creates a database.

I have a mailing list, where the state field draws from a look up table with the two initial state abbreviation. Each state was give an id #.

As far as I can tell, the forms work properly. They display the state abbreviation (MI,) in a drop-down list whereas the table shows the appropriate id# (23).

But when I try to run a label report with the Label Wizard. The state # is displayed not the state abbreivation.

I don't want to confuse our local post office with labels that say Ann Arbor, 23 49707. Can anyone provide assistance or suggestions?

Thanks!!!

1 reply

by tgray

There are two options.

1. Create a query that selects the main data records and add in the lookup table and link it to the main table via the State ID field, include the State Abbrev field in the queries output grid. This will give you your data and include the State Abbrev. Now use this as the source for your label wizard.

2. Modify your main table to store not the state ID # but the actual Abbrev. Modify the pull down list on the form to match (ie just list & store the state abbrev) - that way it is storing what you need directly.

If you need more info, shout!

This discussion is closed to new replies.