Search results

  1. A

    Query that result incremental number, with no Auto-Number

    Well, here's my database : Name : String Address : String I want to add an automatically generated column, "no.", to show which number it's in. Like this : No. Name Address 1. A Unknown 2. B Unknown2 The problem is, I can do that with Auto-Number, but if the user delete row 1...
  2. A

    Update all records with random value ?

    Thanks for supporting me. I've found the answer "yesterday". Basically, it's simple, I just need a field with auto-generated number. Here's the field : Auto : Number (Long Integer) Random : Double And just call RND(Auto) - this will generate random value for all records. UPDATE TABLE_NAME SET...
  3. A

    Update all records with random value ?

    Thanks for reply, but I really want to update all records with random value, RND() function will duplicate the random value to all records. The help say something about 'Randomize' but I cannot use it in query. I'm using Delphi and ADO to access "MS Access" Database. Randomize in my program...
  4. A

    Update all records with random value ?

    This is my first post. Please help me. Here's my DB : Status : Number (Long Integer) Random : Number (Double) If Random value is around 0-0.9, the status value is 1 If Random value is around 0.9-1, the status value is 0 Here's my Query : UPDATE DB Set Random = RND() Rnd() give random...
Back
Top Bottom