Search results

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

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