lookups ?

[Guest]

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.?

 

[Byron]

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.?