Append query help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
I have 2 tables, let's say A and B. Both tables are basically the
same with a few differences. Table A has records from 1/1/04 to
8/13/06, the date/time field is one field with date/time format, about
10 other fields are in text format but need to be changed to number
format. All other fields are exactly the same and don't need to be
changed. Table B has records from 8/13/06 - 12/31/06, with a date
field with text type and a time field with text type, with the 10
other fields in the proper number type.

I need to make one table to include all records from 1/1/04 to
12/31/06, with date/time field in one field with date/time type, and
the other 10 fields I mentioned to be in the number type and the rest
of the fields to remain the same.

I have tried to do this with a MakeTable querie but that didn't work.
I also tried with an append querie but that didn't work either. I
don't know what I am doing wrong. Each way I tried I ended up only
with the records for 8/13/06 - 12/31/06. I also couldn't get the date/
time field to change from 2 fields to one field with the type as date/
time.

Thanks for any help you can give me.

.

Relevant Pages

  • Re: Append query help
    ... Ken Snell ... 10 other fields are in text format but need to be changed to number ... I have tried to do this with a MakeTable querie but that didn't work. ... time field to change from 2 fields to one field with the type as date/ ...
    (microsoft.public.access.gettingstarted)
  • how to break the bounds of 59 in data/time data type
    ... when i select "Data/Time" data type for my time field then ... this format gives the liberty to record times uptill a figure of 59 in ... i am a very basic user of access or for that matter any database. ...
    (microsoft.public.access.queries)
  • how to break the bounds of 59 in date/time data type
    ... when i select "Data/Time" data type for my time field then ... this format gives the liberty to record times uptill a figure of 59 in ... i am a very basic user of access or for that matter any database. ...
    (comp.databases.ms-access)
  • Re: how to break the bounds of 59 in data/time data type
    ... The way to do this is not to use a date time field, ... Combining those and the format function you can end up displaying the data ... i am a very basic user of access or for that matter any database. ...
    (microsoft.public.access.queries)
  • Re: Medium Time format showing seconds
    ... You can update once for all, but that 'destroy' the original information ... that specific format, keeping the original second presents in the field. ... like 2.3, that would be formatted as 2, to display only the integer ... I have several tables that use a time field. ...
    (microsoft.public.access.queries)