1 post in this topic
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:
Is there a way I could make this appear in columns?
1. a) 4. c) ...
2. c) 5. a)
3. a) 6. a)
1. a) 3. a) 5. a) ...
2. c) 4. c) 6. a)
Here is what I am doing from an excel spreadsheet
Jan Feb Marc Apr May June Jul Aug Sep Oct Nov Dec
1.2 1.2 1.2 1.2 1,0 1,1 1,1 .9 .9 .9 .8 .7
.7 .4 .5 .5 .9 .8 .9 .5 .5 .5 .6 .5 Employee 111
.5 .8 .7 .7 .1 1.1 .2 .4 .4 .4 .2 .2 Employee 222
So it adds up to the requirements.
I then want to pull an employee report that shows all the programs and total hours they are needed for. Woudl also like to pull program reports
Can somebody get me started?
I'm sorry if this is really obvious or the wrong place to post this, but I have been having a real frustration with FM Pro databases recently. I am editing my website databases using ODBC. As I tend to edit fields en masse, I use the "view as table" browse mode. In a lot of my columns, the fields I have contain more data than the column width will show. So I've tried adjusting the column width, but it won't let me. I've used the drag to resize function, and the right click and set column width one, but in both cases my column width remains the same. Does anyone have any ideas of what I can do to set them? I've looked through all the help info, forums and googled the problem but have got nowhere.
I took a screengrab, but the arrow one didn't show up. I'm attaching the right click one.
Thanks for any help.