G
Guest
Hi,
I have a table, it is 20 columns, and 75000 rows
I want to update the values in columns 5,17,3 and 4 such that
Col# = Max(Col#,0)
So the negative numbers are changed from negative numbers to zero.
1. I tried "MakeTableQuery" ColumnHeader5:
IIF(ColumnHeader5<0,0,ColumnHeader5)
But this gives a "Circular Reference" error.
2. I tried an "UpdateTableQuery" in
Criteria = <0
Update To = 0
This doesnt work
Thanks for your help
I have a table, it is 20 columns, and 75000 rows
I want to update the values in columns 5,17,3 and 4 such that
Col# = Max(Col#,0)
So the negative numbers are changed from negative numbers to zero.
1. I tried "MakeTableQuery" ColumnHeader5:
IIF(ColumnHeader5<0,0,ColumnHeader5)
But this gives a "Circular Reference" error.
2. I tried an "UpdateTableQuery" in
Criteria = <0
Update To = 0
This doesnt work
Thanks for your help