how to change the value in a querry column automatically.

[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...

 

[Rick Brandt]

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?

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.

 

[Guest]

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)