Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2007-11-29
2
Medium Priority
?
6,826 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 750 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 750 total points
ID: 20373965
type mismatch : check field3in table 3 has a different data type or size in table 2
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

886 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