If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
negative autonumber
I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of them The table is being populated via a form where the ID filed is filled automatically. I have been adding records for several days and everything was OK untill today I noticed, that all the records I added today have been assigned the same negative ID -02 And even one of the records I enetered time ago, changed its ID to -2 What is going on and how do I fix it? a |
#2
|
|||
|
|||
negative autonumber
Hi aa,
It a long shot - but try expanding the width of that column in your view, since the presentation of numbers changes when the width is too small and the '2' may be coming from 1E+02 when you have more than 100 entries. You mention the number is negative which does not align with this theory, but I suggest check it anyway. Regards - laurie Eaton "aa" wrote: I have an ID field set to autonumber. The table has a primary key combined of three other fields, ID is not one of them The table is being populated via a form where the ID filed is filled automatically. I have been adding records for several days and everything was OK untill today I noticed, that all the records I added today have been assigned the same negative ID -02 And even one of the records I enetered time ago, changed its ID to -2 What is going on and how do I fix it? a |
#3
|
|||
|
|||
negative autonumber
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
autonumber | Deepak | General Discussion | 3 | June 18th, 2004 09:07 PM |
multiplying a negative time value by a monetary rate | apogee | General Discussion | 1 | June 13th, 2004 12:37 AM |
Negative numbers in formulas | Bob Phillips | Worksheet Functions | 5 | January 13th, 2004 05:13 PM |
Negative dates or times are displayed as #### | John Sheakley | Worksheet Functions | 1 | September 30th, 2003 03:38 AM |