Multiple codes in a field
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 14, 2008 8:09 AM
UPDATED:
October 21, 2008 3:55 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
