increment each row of table

BurhanKhan · September 25th, 2004, 08:31 AM

Hi:
i want to update some rows of myTable of Access.
i.e if previous value is 5 , then it should be updated by 6.

i use this query to increment value of each row by 5:

update MyTable set p = (select p+5 from MyTable where catID = 2) where catID = 2"

But this query have problemm.
How i do that?

Thanks
Burhan

happygv · September 25th, 2004, 10:33 AM

Hi,

You don't have to use subquery to set value there. That is not the right approach. Rephrase your query it to this.

Code:

update MyTable set p = p+5 where catID = 2

This would be enough to get that work.

Cheers!

_________________________
- Vijay G
Strive for Perfection

BurhanKhan · September 25th, 2004, 11:34 AM

Thanks Happygv