|
| 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
February 14th, 2007, 04:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Appending Overwriting, instead of appending
I can't figure this one out - an append query is overwriting the first record
in the table, instead of appending it to the end. Please help - thank. 
|
|
#2
February 14th, 2007, 04:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Appending Overwriting, instead of appending
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here. Information on primary keys and relationships would be a nice touch too. Also any indexes. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Anne" wrote: I can't figure this one out - an append query is overwriting the first record in the table, instead of appending it to the end. Please help - thank.
|
|
#3
February 14th, 2007, 06:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Appending Overwriting, instead of appending
Another thought: Are you sure that it's overwriting the first record in the
table OR it's just showing up first when you open the table? What is the primary key field for the table? That's how you can tell. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Anne" wrote: I can't figure this one out - an append query is overwriting the first record in the table, instead of appending it to the end. Please help - thank.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
