Multiple codes in a field

Tags:
Database programming
Microsoft Access
Hi there, I'm a complete Access noob, but I need to figure something out! Is it possible to put more than one code in one field? For example I need to answer 500 letters. Each letter has a code say 01-500. In each letter there are 3 questions that need to be answered, but half of the questions in these letters are the same. The database is ordered by question but I need to be able to link multiple letters to one question. For instance: Q 0756 was asked by letter number 34, 287, 289, 412 and 489.I also really need a way to be able to immediately see that letter 387, question one is answered in Q 354, question two is answered in Q 122 and question three is answered in Q 567. Can anyone help me and give me some advice on how to tackle this problem?
ASKED: October 14, 2008  8:09 AM
UPDATED: October 21, 2008  3:55 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is a multiple value data type in Access 2007 that allows comma delimited data to be entered. Not sure this is the best way to go. I would create a new table called Answered that looks like this:

question_letter_id long integer
question_number long integer
answer_letter_id long integer

This way you can look up an letter with a question and see what letters had the answer. If you have a separate question table, you could store the questions separately and use this table to show what letters had which question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following