Jump to content

Variable data into columns


This topic is 2336 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

Thank you for your interest comment.

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

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. :bye:.

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.

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 2336 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.