Solved

Append Query (SQL Insert Into) does not insert all values

Posted on 2007-11-29
2
6,817 Views
Last Modified: 2008-02-01
Hey all,
MS Access 2003.

the following SQL statement runs and works ok except for Field3:

INSERT INTO Table3 ( Field1,Field2,Field3)
SELECT Field1, Field2, Field3
FROM Table2;

it inserts all of the others however Field3 in Table3 remains blank.  The only difference I can see is that Field3 in Table3 has a lookup to another table which has a rowsource of
SELECT Field_ID, Field3 FROM Table1 ORDER BY Field3.

Any ideas why I can't insert into Field3 Table3?
0
Comment
Question by:Surferprime
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 20373772
unless there were some errors raised, there must be some other typo or the like making the field3 in table3 remains blank.
when you run the select statement only, does it properly return the data?
do both fields (field3 on the 2 tables) have the same data types and sizes?
0
 
LVL 5

Assisted Solution

by:balmasri
balmasri earned 250 total points
ID: 20373965
type mismatch : check field3in table 3 has a different data type or size in table 2
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question