More than likely an easy remedy

[waffle]

I have two tables and one has Job Associated Name and the date we began the job, the other table has the job associated name, however it is repeated. I want to have the date show up on the other table so that I can have it appear on a report. The two tables are linked by job associated name.

 

[KenHigg]

Bring both tables into a query, link them on the common field, a bring down the fields you want...

 

[waffle]

Tried running an append query and I keep getting a key violation...

 

[waffle]

I also am trying to take the year from the job and turn it into a number in that field so that we can just sort by a year rather than a date. I haven't even begun to attempt that one yet, its still a pipe dream but one can hope cant he?

 

[The_Doc_Man]

You don't want an APPEND query. You want a SELECT query with a JOIN clause. Look up JOIN in Access Help.