Append Query always says Your are about to append zero rows

[Thomas1]

Hi Guys,



I can not get my Append Query to work.

I have read everything on the internet, tried every thing and still can not get this to run.

I always get the same out put: "you are about to append zero rows"

The Table "JobData" has four rows of test data and I want to beable to update the table "Recap"

I have attached the Access file for your reference.

Thanks you so much for your help! I am at my wits end!!

Tom

[ranman256]

remove RECAP table from the query
you want to add JOBDATA not jobdata fused with recap. Dont add recap to itself.
only jobdata needs to be in the query.