Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jroldan

    Auto Incrementing Fields

    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
  2. jroldan

    Auto Incrementing Fields

    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...
  3. jroldan

    Auto Incrementing Fields

    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...
  4. jroldan

    I need to do some rounding.. I hav

    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

Part and Inventory Search

Back
Top