Automatic zeros in table??

[jeffro]

Ok, I have tried everything. I'm trying to put zeros within 3 fields from my table. I have used an update query 'in the update part I put 0 and in the criteria part I put Is Null'. I have also tried putting Is Null Or "" in the criteria. None of the above has worked for me. Does anyone have any other ideas besides putting the zeros in myself. Lord knows I don't want to do that!

Thanks jeffro

[Lafor]

what is type of these fields?

send your update query...

Make it a good day!

[jeffro]

The fields types are just numbers. Like this 0.00.

Do you have any email address for me to send the update query?

Thanks jeffro

[Lafor]

hlaforest@adheris.com

[parksie]

UPDATE TABLE tablename SET fieldname=0.00 WHERE fieldname IS NULL

Would that work?

[jeffro]

No sorry parksie. I just tried what you suggested and it didn't update any of the rows.

Thanks for trying!

jeffro