How to Add Values to A field in a Table

**rjbautista20** · 05-03-2012, 01:22 AM

Hi Guys,

I have a huge database size now and I want to Archive it to another Access Database.

i Linked the Archive Table to my Main Access Database.

User must name their archived respective...

For example:

From: Main Access Database, i have Field1, Field2, Field3 and in my Archive Database i have YEAR, Field1, Field2, Field3

I created a button to append the data to the Archive Database, after user input for example YEAR2012, in my archive table should be

YEAR - 2012
Field1
Field2
Field3

how do i this?

Please help.

THanks.

**alansidman** · 05-03-2012, 09:45 AM

I'm afraid that your explanation is not quite clear. Please try to explain further what you are trying to do. Also, what does this mean?

User must name their archived respective...

**rjbautista20** · 05-03-2012, 09:16 PM

@alansidman,

i'm sorry if its not clear.

i have two tables, MainTable and ArchiveTable

In Maintable fields are Field1, Field2 etc.

In ArchiveTable fields are Year, Field1, Field2

I need to archive all data from Maintable to ArchiveTable but user should enter a name to label all data.

Example:

From Maintable

Field1 - 1
Field2 - 2

To ArchiveTable

Year - year2012
Field1 - 1
Field2 - 2

hope i explained it clearly already... sorry again.

Thanks.

**alansidman** · 05-04-2012, 07:07 AM

Sounds like a simple append query. Here is a tutorial on append queries. You will need to run an update query on the first table before appending it to the second one. The second link is a tutorial on update queries.

http://office.microsoft.com/en-us/ac...010076526.aspx

http://www.techonthenet.com/access/queries/
Then scroll down to update queries