troubleshooting Question

How to create Access 2013 field with only 2 possible values

Avatar of ArchiTech89
ArchiTech89Flag for United States of America asked on
Microsoft Access
33 Comments6 Solutions236 ViewsLast Modified:
I have a really simple question. I just need to create a field in a table that will track whether a job opening record requires a Lebenslauf auf Deutsch (German resume) or an English one. I want to be able to choose "Deutsch" or "English" (English is default), but have DE or EN recorded in the database. This field represents a flag for a mail-merge effort to automate cover letter customization -- I want to be able to run the merge for just one language based on a query of this field.

I know it's simple, but you'd be surprised how difficult it is to find this kind of info through a search engine. (Either that, or I'm not very good building search engine queries...)

Thanks in advance.

P.S. I thought about building a lookup table, but it seemed to be overkill for just 2 languages. Is that a correct assessment, or would it be a good approach after all?
Join our community to see this answer!
Unlock 6 Answers and 33 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 6 Answers and 33 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros