[AccessD] Append (?) Query Help

Gary,

The field is a date field. I tried making the blanks = N/A
but they would not take.

The source table was a non normalized table that I broke to
several smaller tables to normalize the data.

I missed taking the Term Date field the first time through.
Would it be easier just to rebuild the target table?

Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gary Kjos
Sent: Wednesday, November 30, 2005 12:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com