[AccessD] Append (?) Query Help

I would change it to just a plain select query and see what results
you are getting. Are you getting nulls in one of those two fields??
Perhaps you have some bad records? Perhaps you need a condition to
select only if is not null or something?
Is that enough info to actually add the record in the table you are
trying to insert into?


On 11/30/05, Joe Hecht <jmhecht at earthlink.net> wrote:
> I am trying to add a field of data from one table to
> another. The idea is to add the term date to the target
> table. It errors out to key violation and null values.
>
>
>
> Please advise.
>
>
>
> SQL =
>
>
>
> INSERT INTO 01tblPersonel ( MyEmpNumb, Term_Date )
>
> SELECT [01_PersMasterfor Programming].MyEmpNumb,
> [01_PersMasterfor Programming].TERM_DATE
>
> FROM [01_PersMasterfor Programming];
>
>
>
> Joe Hecht
>
> jmhecht at earthlink.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com