Re: Example of a append query and a update query

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

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 07:06:09 -0800

Karen

It is fairly unusual to have two tables with the same structure, IF you have
a well-normalized relational database. If you have a spread***, that's
very common.

If you want to see examples of append and update queries, Access HELP
provides those.

Note: if you'll describe the "why"/your business need, there may be
alternate approaches you could use. For example, one reason to have
identical structures in two tables is in an attempt to "archive" records. A
much easier way to do this is to add a single field to a single table. That
field can be a Yes/No, if you only need to know ?Archived?, or a date/time
field, if you want to know "when". Putting a valid value in that field
means the record is archived.

Then, you only need to modify your queries to look for "non-Archived" rows
to see all the "active" rows. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"Karen Middleton" <karenmiddleol@yahoo.com> wrote in message
news:a5fd468a.0412270422.310b0bf3@posting.google.com...
> Can you please give me a sample of a append query and a update query.
>
> Apart from append and update query what other query types do we have.
>
> I have a scenario where I have table1 and table2.
>
> The structure of table1 is the same as table2.
>
> What I want to do is if for every record in table1 if it is present in
> table2 I want to replace the table2 record by the table1 record. If
> the record in table1 is not present I want to insert the record in
> table1 into table2.
>
>
> Please advice how I can do this.
>
> Thanks
> Karen
Quantcast