[AccessD] Append (?) Query Help

Date/time fields are actually stored as double precision numeric
fields internally, so anything alpha or blanks/spaces is gonna break
it. You can do mathematic stuff with them though, so you could test
for <>0 or something or perhaps a date > the earliest date you have in
your date population?? > #1/1/1900# or something like that.

Have a look at this description of the date field's structure....I
learned about this when doing Y2K stuff back in 1999 ;-)


http://support.microsoft.com/?scid=kb;en-us;210276&spid=2509&sid=202

Ya got to give it what it wants. Or skip the things it can't handle.

GK



On 11/30/05, Joe Hecht <jmhecht at earthlink.net> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com