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
|
|||
|
|||
HELP ADDING RECORDS
I need to know how to add a record inbetween two records
that I already have. I have been looking in the help, in books, and on the internet and can't find anything about that. If anyone knows how to do this please let me know or if you know of a different way to do this. THank you Katrina Kleinhans |
#2
|
|||
|
|||
HELP ADDING RECORDS
There is no "between" in Access records. Records in a table have no order
until you apply an order. You must store a value or values in the table that describe or desired sort order. Changing the value of a "sort field" will allow you to display your records in different order. -- Duane Hookom MS Access MVP "Katrina Kleinhans" wrote in message ... I need to know how to add a record inbetween two records that I already have. I have been looking in the help, in books, and on the internet and can't find anything about that. If anyone knows how to do this please let me know or if you know of a different way to do this. THank you Katrina Kleinhans |
#3
|
|||
|
|||
HELP ADDING RECORDS
Katrina
Duane's already pointed out that an Access table is a "bucket-o-data", with no order unless you provide a way to tell Access how you wish to see the rows ordered. I'm curious ... WHY do you want to insert a record in between two others? What underlying business need are you trying to meet by doing that? -- More info, please ... Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subform Default Key Value when adding new records to table | James | Using Forms | 5 | June 17th, 2004 05:08 PM |
Help with using drop-down menus to limit choices when adding records or viewing queries | Mike H | New Users | 1 | June 8th, 2004 06:46 PM |
adding records to linked tables | New Users | 6 | April 27th, 2004 03:24 AM | |
Word 2003 is adding duplicate records to my mail merge | Doug Robbins - Word MVP | Mailmerge | 0 | April 24th, 2004 03:58 AM |
Adding to already linked records | Amanda | Worksheet Functions | 8 | December 24th, 2003 07:01 AM |