Question How to count points for marks

[butek]

Hello
It is my first post here.
I have table with names of students anf their school marks and second table with points for a school marks .

How to count students points for these marks ?

 

[isladogs]

Can you please explain in more detail.
It would be useful to see some examples of the values that you are referring to

 

[butek]

Can you please explain in more detail.
It would be useful to see some examples of the values that you are referring to

Im a teacher and I must prepare recruitment system .
So
My future students (candidates) have any marks from previous school. My school give for their marks points. Who have the most will be future students my school.
So I have to change marks to points. Teacher who will be work with my aplication will be write only marks and system convert it to points.
Good explantion ?

 

[isladogs]

Sorry but no. I understood that much from your first post
I'm an ex-teacher myself.
What I wanted to know was the conversion from marks to points

 

[butek]

Candidate have three marks : 5,4,3 . Three subjects and three marks. My school give for 5 - 10 points, for 4 - 8 points and for 3 - 6 points. How to convert/count/solve total points for each of students.
OK ?

 

[isladogs]

No.
Either you don't know what the marks to points conversion is or you just aren't telling me. Without that information, I am unable to assist.

 

[MajP]

If I understand correctly it looks like you are saying that points equals 2 * Marks. Is that correct? Is there more to it?

for 5 marks = 10 points,
for 4 marks = 8 points
3 marks = 6 points

 

[butek]

Candidate have three marks : 5,4,3 . Three subjects and three marks. My school give for 5 - 10 points, for 4 - 8 points and for 3 - 6 points. How to convert/count/solve total points for each of students.
OK ?

Sorry for my english marks=grade


So for grade 5(grade)= 5 * 10=50 points.
Is that clear ?

 

[isladogs]

Butek
When I read MajP's reply, I thought he understood what you meant perfectly.
Now you've mentioned grades for the first time with a 10x multiplying factor.
So I'm unclear again and am going to drop out of this thread.
Good luck with finding a solution.

EDIT:
Now crossposted at http://www.accessforums.net/showthread.php?t=74915

 

[arnelgp]

your second table should have both mark and corresponding point, eg:

table2
-------

Mark           Multiplier
---------      ------------
3               6
4               8
5               10

create a query that will multiply it:

select mark, dlookup('multiplier','table2','mark=' & [mark])*[mark] as point from table1;

 

[butek]

Thank you for your answer but I want change mark into points.

 

[arnelgp]

create another field on the table you want to update (say Point).
then you only need to use update query (if you already made the table i posted a while ago).

update table1 inner join table2 on table1.markfield=table2.mark set table1.point=table1.mark*table2.multiplier;

 

[akhon]

You want to say that you are indicating the marks to point.
e.g., if the student get 83marks out of 100 and you want to indicate that marks into point. right.
if yes, then
first of all you should know that how much marks is equal to point. say 80-100 marks is equal to 10, 60-80 =8, 40-60=6 and so on......
if you wanted to say above one then you can convert marks into points by using queries...