Award Customer Points based on sum of Columns

[JohnBoy]

Pretty new to this VBA stuff especially in Access, I can do the docmd stuff etc and some SQL but I have come up against a small problem I could use some help with,
I have inherited a database which I am currently trying to bring some sense to and make more useful,
I have a number of columns in a table relating to customers purchases and need to work out a way to award points per row of data,
So lets say there are 16 columns,
Col A has a customer ID recorded in it, say RA123456
Col B has the main product class number say R123 recorded in it.
The remaining columns have sub category reference number in them say A123 B123 C123 etc etc,
I have a look up table that contains all of these categories etc and a points system that goes with them,


What I want to do is have a new column (17) in my main table look at all of the reference numbers in the row and award a number of points to the row based on the sum of the look ups,
Is this possible and if so any help would be gratefully received

[llkhoutx]

The new colum will have a field which sums the appropriate columns, e.g.

Column17 field is
SumofColmuns: nz(A123) + nx(b123) + nz(b123) + ...

Note that the NZ function is used on the column values to avoid adding a null value which would destroy the sum.

[JohnBoy]

Many thanks I will give it a go and let you know how I get on

[JohnBoy]

All working many thanks