how to change the value in a querry column automatically.

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

Guest

hi everyone!
i need help.

given:querry columns of "size" & "core"
problem:
i need to change all the values of 2.5 to 4 in column "size" when it
encounters a value of 3 at column "core".
question:
i want to have the result reflected at the very same querry.is it
posiible?can you help me with a sample syntax?

thanks very much for your time...
 
xian said:
hi everyone!
i need help.

given:querry columns of "size" & "core"
problem:
i need to change all the values of 2.5 to 4 in column "size" when it
encounters a value of 3 at column "core".
question:
i want to have the result reflected at the very same querry.is it
posiible?can you help me with a sample syntax?
Click to expand...

NewSize: IIf([size]=2.5 AND [core]=3, 4, [size])

The above will output 4 for each row where size = 2.5 and core = 3. On all
other rows the existing value of size will be output.
 
I don;t know about updating queries.,

But something like

Update Queryname Set Size = "4"
where core = "3" and size = "2.5"

I believe even numbers need quotes in updates.


Hi everyone!
i need help.

given:querry columns of "size" & "core"
problem:
i need to change all the values of 2.5 to 4 in column "size" when it
encounters a value of 3 at column "core".
question:
i want to have the result reflected at the very same querry.is it
posiible?can you help me with a sample syntax?

thanks very much for your time...


(e-mail address removed)
 
Back
Top