I'm trying to collect the correct answers from a test exam.

For example, 35 questions, a, b or c as possible answers.

I've made a script with a variable into a loop that collects the data such as: $Var [ question number & "space" & correct answer & "carriage return" & $Var ].

With it I get something like this:

1. a)

2. c)

3. a)

4. c)

5. a)

6. a)

...

Is there a way I could make this appear in columns?

Like

1. a)     4. c)   ...

2. c)     5. a)

3. a)     6. a)

or

1. a)     3. a)     5. a)     ...

2. c)     4. c)     6. a)

Thank you.

29 minutes ago, Enigma20xx said:

35 questions, a, b or c as possible answers.

Are those 35 records? (Hint: they should be).

If yes, then you could simply show them in side-by-side portals, each set to start on a different row. Or print them in columns (you didn't say why you need this).

If not, see:
http://www.briandunning.com/cf/880
http://www.briandunning.com/cf/878
http://www.briandunning.com/cf/877

 

Edited February 5, 20169 yr by comment

Thank you for your interest comment.

And as always you are right I want it for printing and I didn't say it .

This is one of my oldest db. So when I did it I didn't have much knowledge about FM (still haven't improve much ), so trying to make a simple example file to attach, I realized that the ERD hasn't a "good look". All data is in the same table (exam definition [date, model, type...], questions and answers). Years ago all worked fine because I only need to print them in order. .

I'm sure that when I'll fix it, more problems will show up.

By now, I can collect the correct answers using the script step I mentioned but I get the info in "horizontal way", I mean:

1. c     2. a     3. b

4. c     5. b     6. b

Changing the field size I can make it appear in columns, but not in a vertical column look.

If you have any advise about the correct ERD, I'm all ears .

Thanks again.

19 minutes ago, Enigma20xx said:

If you have any advise about the correct ERD, I'm all ears

This has come up several times - do a search for "survey". In general, it would look something like:

Exams -< Questions -< Responses >- Subjects

 

 

Edited February 5, 20169 yr by comment