Update query on definite record(row) of table.

[Dixie]

I have a two column table which has a value for the current calendar year on
a definite row(record) of the table, which could be described as ID=100.

The value is in a field called txtValue. There are over 100 records in this
table. I want to be able to look at the Datepart("yyyy", Date()) and update
the value in txtValue in record ID=100 to that value.

I would like to do it with an update query. Is that possible? If so, how,
if not, how do I achieve this. It has to be done programmatically, as it is
just a part of a larger procedure.

TIA
dixie

[Bob Quintal]

"Dixie" <di***@dogmail.com> wrote in
news:43******@duster.adelaide.on.net:

I have a two column table which has a value for the current
calendar year on a definite row(record) of the table, which
could be described as ID=100.

The value is in a field called txtValue. There are over 100
records in this table. I want to be able to look at the
Datepart("yyyy", Date()) and update the value in txtValue in
record ID=100 to that value.

I would like to do it with an update query. Is that possible?
If so, how, if not, how do I achieve this. It has to be done
programmatically, as it is just a part of a larger procedure.

TIA
dixie

Do you mean that the ID column is the primary key of the table?.
If so then just:
UPDATE TableName
SET TableName.txtValue = Datepart("yyyy", Date())
WHERE ((tablename.ID)=100);

--
Bob Quintal

PA is y I've altered my email address.

[Dixie]

Silly me, how simple.
Thanks Bob.
dixie

"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...

"Dixie" <di***@dogmail.com> wrote in
news:43******@duster.adelaide.on.net:

I have a two column table which has a value for the current
calendar year on a definite row(record) of the table, which
could be described as ID=100.

The value is in a field called txtValue. There are over 100
records in this table. I want to be able to look at the
Datepart("yyyy", Date()) and update the value in txtValue in
record ID=100 to that value.

I would like to do it with an update query. Is that possible?
If so, how, if not, how do I achieve this. It has to be done
programmatically, as it is just a part of a larger procedure.

TIA
dixie

Do you mean that the ID column is the primary key of the table?.
If so then just:
UPDATE TableName
SET TableName.txtValue = Datepart("yyyy", Date())
WHERE ((tablename.ID)=100);

--
Bob Quintal

PA is y I've altered my email address.