Search results for query: *

I was attempting to do some clean up and repair on table. I tried writing code for it and came to this issue so I figured I'd ask and make sure I wasn't doing anything wrong. I appreciate everyones feedback on this. Thanks, Jerry

Thanks Mike, I just needed to make sure there wasn't a easier way. Right now I'm changing the field to an integer manually through the command Windows, and running this simple code: x=1 Do while !eof() replace file_cnt with x skip 1 x=x+1 enddo I just thought there was a way to do that...

I have a table with auto increment on with a start value already up to 33, and it steps up by 1. When I go to update a record and decide to cancel it, the table still updates the auto increment value by 1, which throws off my count since now the value is at 34. Is there a way to set the auto...

I need to do some rounding.. I have a database with numbers ranging from .68, 2.94, to 55.97 and so on... I need to round the numbers to the nearest .09 What type of code do I use to replace the .68 with .69 or 55.97 with 55.99 or the 2.94 with the number nearest to .09? Thanks in advance