Add chart to access form - data populated programatically

[rwahdan1978]

Hi

I want to add data to chart from a form and display that in an other form. Say I have quiz question and I have 4 answers, I will get random percentage of the answers if they are correct or not. Example:

Q. What is the capital of UAE?
A1. Abu Dhabi
A2. Dubai
A3. Sharjah
A4. Ajman

the correct answer is A1 which is Abu Dhabi. Now based on that I will have random percentages such as:


A1. 67%
A2. 23%
A3. 7%
A4. 3%

after that I will user this data to dispaly the bar chart

[June7]

Data must be in table or calculated in query for use in chart.

How would you get 'random' percentage? Why should a wrong answer have any percentage?