Really Simple question

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
In your Update query, did you put multiple criteria in, or did you try it
for simply one field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top