hello there i have 9 tables with out any relations that they are different tests for each items in the AAHPERD test, my question is about adding the someone's ranks into access db by a single form and i need to calculate the output rank by comparing each tests rank and estimate the final rank from the Constant tables that i defined...
i will tell you an example by sending the ms file here; but let me explain it to you:
- i have constant tables with only 2 columns the first column is the defined score and the other is the player rank.
- i have 9 tables
- each table is calculated from 0 to 100 score
- all the tables are major and necessary to calculate (each item needs to be calculate for the average score)
- i want to add items ranks manually for each fields and let the ms calculate the average score
- i don't want to edit any constant tables(2)
- i have a unique table to compare table and the form1 is related to that compare_table.
i made the tables for all of the items by excel then imported to ms access, made a table named compare that i want to use it to compare the item scores from player rank and constant one from the related table! but i couldn't do that!
like this:
running45mtbl : score rank
100 8.5second
etc etc
manual input in form1:
form1: name playerID running45m
dave 112 8.5
when i put 8.5 second data in running45 field i want to the ms access give 100 score to my compare table and so on to the latest field in form1, then the program just calculate the average from 9 tables (from 100 score)... and show to me the latest score and save it in compare table.
output saved:
compare_table: name playerID running45m
dave 112 100
etc.
sorry im not native english speaker.
aahperd.zip