Simple Field Update?

M

MarkyB

I have a table in a SQL database (autonumber_id, name, count, extract,
points). I have set up a form in an Access front end that looks directly at
this linked table and can add/amend/delete records from it. Easy.
What I would like to do is automatically populate the points based on the
combination of the count and extract fields. These two fields have been set
up on the form as tick boxes.

How can I do this so that the points field is updated without going down the
VB route.

Thanks,

Mark
 
D

Douglas J. Steele

If points is strictly based on the value of other fields in the same row,
you shouldn't be storing it.

Instead, you should create a query that calculates the value, and use the
query wherever you would otherwise have used the table.
 
M

MarkyB

Thanks for your advice Doug, but we do require the points to be stored. This
is part of an audit table for us and it is necessary to keep this information
as it will be queried directly from SQL at other times.
 
D

Douglas J. Steele

An Update query should let you do it.

Sorry, but without more details of the table and the calculation, I can't
offer sample SQL.
 
Top