Newbie: Negative Values To Zero

[Stefan Seifarth]

Hi,

i've got a simple question. I know it should be easy to solve, but i didn't
find the solution. Here is my question. I want to find all values in a
single column <0 and set them to 0. Other values should remain. Is there a
simple solution in a single query?

Thanks
Stefan Seifarth

 

[Niklas Östergren]

You could make an Update query using a select query as recordsource where
you select the records with the valur you would like to update to 0.

// Niklas

 

[Arvin Meyer]

It is easiest with an Update query. Example:

UPDATE MyTable SET MyTable.MyField = 0
WHERE (((MyTable.MyField)<0));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access