Solved

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

Posted on 2007-11-29
2
6,822 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

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…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

627 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