Nick,
The short answer is: "Yes", it can be done. Try using the
DLookup function. You should be able to find info on this
function in the Help file.
However, I think that you might want to take a look at
your database for normalization. You should not have to
repeat any value in a second table. You should be able to
just retreive the value through a query by linking the
two tables.
HTH
Byron
-----Original Message-----
I want to make access xp automatically find a value from
1 table and add it into another. e.g a student scores 10
in a test. this is worth 30 marks afther a conversion
(set up in another table) i want 30 to appear in the
column after 10 in the first table. can it be done.?
