Linked Table Bringing in Blank rows

[ShannaD]

Why would a linked table be bringing more rows than those that actually have
data in them? The size of the linked table changes from day to day but the
empty lines are blank so I can't figure out why it would be importing them
when I do an append query.

This is an Access 2003 database.

Thanks for any help!
Shanna

 

[Damon Heron]

Post your append query...

 

[ShannaD]

INSERT INTO TblMainData ( [Work Order], [Part Number], [Material Code], Qty,
[Cut-to-Size], Project, CC, Warroom, [Date Added] )
SELECT QryExtModified.[WORK ORDER], QryExtModified.[PART NUMBER],
QryExtModified.[MATERIAL CODE], QryExtModified.QTY, QryExtModified.CTS,
QryExtModified.PROJECT, QryExtModified.CC, QryExtModified.WARROOM, Date() AS
[Date Added]
FROM QryExtModified;

 

[Damon Heron]

Your qry seems fine. But you said the "empty" lines are being brought in
when you run the query.
What is an empty line? A record either exists or it doesn't. Do your
tables have primary keys?

Damon

INSERT INTO TblMainData ( [Work Order], [Part Number], [Material Code],
Qty,
[Cut-to-Size], Project, CC, Warroom, [Date Added] )
SELECT QryExtModified.[WORK ORDER], QryExtModified.[PART NUMBER],
QryExtModified.[MATERIAL CODE], QryExtModified.QTY, QryExtModified.CTS,
QryExtModified.PROJECT, QryExtModified.CC, QryExtModified.WARROOM, Date()
AS
[Date Added]
FROM QryExtModified;

Post your append query...

 

[Fred]

It's common to get more "records" (actually, query output lines) than
either table if the fields on both sides of the links have duplicates.
Having one side of the link being a primary key prevents the structural and
data entry problems that cause this to occur.