un - archive

[Driftwood]

Hello,
First I must say that we are trying get rid of the "store"-version of a
database we bought, and trying to make our own database, so we can link up
and specialize the tables to what WE need.
I am new at all that is ACCESS...
I am trying to retrieve data from dates ranging from 1/1/08 - the last
archived entry of this table to the current running table.
This table will be crucial to the alarm-setting of all product received,
along with several links to other databases (which have returned product,
unsafe product, etc)

We have data from 1999 - April 2009 in an archive file, while the current
file has the data from May 2009 - Current Date.
I would like to have data from 1/1/08 - current in a single table in the new
database - no more archiving, as this causes problems.
I have to have the last two years in the same table.
I have 7820 entries that I would like to add (or retrieve back) to the
"tblReceiving", which has 4949 entries already.
I do not want to copy each row over cell by cell (which works, but each row
has 25 entries)

Any help is greatly appreciated
Thanks
Driftwood

 

[Jeff Boyce]

Remember that "cell by cell" sounds more like a spreadsheet ... Access
doesn't have "cells".

Take a look at using an Append Query. Link to the table with the archived
data, then create an append query to add its records to your "active" table.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.