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
|
|||
|
|||
Inserting a new line
I have the following table:
Item -------- ID - Autonumber Name - Text Amount - Currency If a user enter info into this table, how can I insert a new record between other existing records. Example: ID Name Amount 1 Milk $3 2 Cookies $4 ---------- Insert new record here 3 Meat $10 4 Eggs $3 How can I insert a record between 2 & 3 and get my table reorder so now my record looks like this: ID Name Amount 1 Milk $3 2 Cookies $4 3 my new record here 4 Meat $10 5 Eggs $3 Is this possible?? Thanks! |
#2
|
|||
|
|||
Inserting a new line
Hi,
Data in tables is always unordered so what you want is not possible. It should not matter at all what the order is because you can use an Order By clause in a query to sort it any way you like. HTH Dan Artuso "hin" wrote in message ... I have the following table: Item -------- ID - Autonumber Name - Text Amount - Currency If a user enter info into this table, how can I insert a new record between other existing records. Example: ID Name Amount 1 Milk $3 2 Cookies $4 ---------- Insert new record here 3 Meat $10 4 Eggs $3 How can I insert a record between 2 & 3 and get my table reorder so now my record looks like this: ID Name Amount 1 Milk $3 2 Cookies $4 3 my new record here 4 Meat $10 5 Eggs $3 Is this possible?? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cumulative line chart problems | neowok | Charts and Charting | 3 | June 22nd, 2004 02:52 AM |
The line in a line graph | Andy Pope | Charts and Charting | 1 | June 8th, 2004 10:32 PM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |
How to use (and move) a vertical line as a cursor in x-y plot | Rick Jones | Charts and Charting | 1 | November 3rd, 2003 05:52 PM |