How do i increase values in an update query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to increase a value in an update query? I want to change all
people in year 7 to the year above, e.g. year 8, in an update query, but I
don't know how. Thanks for your help.
 
Carrotsinapod said:
Is there any way to increase a value in an update query? I want to change all
people in year 7 to the year above, e.g. year 8, in an update query, but I
don't know how.
Click to expand...


There may be something wrong with your table design since
this kind of operation should not be needed. (It sounds
just like the problem of storing people's ages rather than
their birthdate.)

However, you can do what you asked by using an Update query.
(Be sure to make a backup before doing this so you can
quickly recover from any mistakes.)

UPDATE table
SET yearfield = yearfiueld + 1

Be very careful that you do not run that query twice.

If you really only want to update the yearfield when it was
7, then add a where clause:
WHERE yearfield = 7
 
if you have any field as year you can update it referencing current date
and birthday.

create an update query and select only field year. at query update line
write Format(date();"yyyy")-Format([birthday];"yyyy") and run query.

you can run querry whenever you want . because it never makes mistakes
gives true results.
 
t said:
if you have any field as year you can update it referencing current date
and birthday.

create an update query and select only field year. at query update line
write Format(date();"yyyy")-Format([birthday];"yyyy") and run query.

you can run querry whenever you want . because it never makes mistakes
gives true results.
Click to expand...


Sorry, but I fail to follow the significance of this
message.

If it's in response to my comment about storing people's age
instead of birtdate, whatever you're trying to accomplish
here would still have to be executed everyday to keep the
age field accurate.
 
Back
Top