Solved

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

Posted on 2007-11-29
2
6,819 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to keep a record with the highest value 3 59
Not listening to where 1 43
T-SQL: Number of Records is Greater Than One 7 51
SqlServer amend PK column 5 14
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

751 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