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

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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"MarkyB" <brazier_marks(dodgybit)@hotmail.com> wrote in message 
news:B5DC489E-93E3-46AA-8D58-C68E119E364A@microsoft.com...
>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 

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.

"Douglas J. Steele" wrote:

> 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.
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> "MarkyB" <brazier_marks(dodgybit)@hotmail.com> wrote in message 
> news:B5DC489E-93E3-46AA-8D58-C68E119E364A@microsoft.com...
> >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 
> 
> 
> 

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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"MarkyB" <brazier_marks(dodgybit)@hotmail.com> wrote in message 
news:F55AA5D6-2230-4868-BB8B-A5D8DC4AC3EB@microsoft.com...
> 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.
>
> "Douglas J. Steele" wrote:
>
>> 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.
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "MarkyB" <brazier_marks(dodgybit)@hotmail.com> wrote in message
>> news:B5DC489E-93E3-46AA-8D58-C68E119E364A@microsoft.com...
>> >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
>>
>>
>>