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?