Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-19-2010, 04:41 AM   #1
JuniorWoodchuck24
Registered User
 
Join Date: Jan 2010
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
JuniorWoodchuck24 is on a distinguished road
Append Query that can append to multiple tables

I'm having difficulties deciding on how to go about saving past information, but I believe an append query is the route to go. What I'm trying to do is once a project's information has been issued then the append query takes those line items from tbl1 and dumps them in tblRevA. So only the projects that have been rev'd up will be appended to the table. Now when tbl1 has info going from RevA to RevB it takes the info from tbl1 and appends the B status info to tblRevB. Was curious if there was a way to code criteria for a Rev Field in the Append Query to look at the Rev column and dump data based on the Rev it is.

Note: tbl1 will always have the most up to date information. the other Rev tables are for comparison so a report can be generated to show the changes made by comparing the different rev's

JuniorWoodchuck24 is offline   Reply With Quote
Old 08-19-2010, 05:35 AM   #2
Trevor G
Newly Registered User
 
Trevor G's Avatar
 
Join Date: Oct 2009
Location: Tamworth, Staffordshire
Posts: 2,331
Thanks: 4
Thanked 229 Times in 219 Posts
Trevor G will become famous soon enough Trevor G will become famous soon enough
Re: Append Query that can append to multiple tables

Quote:
Originally Posted by JuniorWoodchuck24 View Post
I'm having difficulties deciding on how to go about saving past information, but I believe an append query is the route to go. What I'm trying to do is once a project's information has been issued then the append query takes those line items from tbl1 and dumps them in tblRevA. So only the projects that have been rev'd up will be appended to the table. Now when tbl1 has info going from RevA to RevB it takes the info from tbl1 and appends the B status info to tblRevB. Was curious if there was a way to code criteria for a Rev Field in the Append Query to look at the Rev column and dump data based on the Rev it is.

Note: tbl1 will always have the most up to date information. the other Rev tables are for comparison so a report can be generated to show the changes made by comparing the different rev's
It sounds as though you need 2 append queries then you can append to both tables, use a macro run both at once and you can set the warnings to off if you don't want to see the warning box
__________________
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Trevor G is offline   Reply With Quote
Old 05-24-2011, 08:05 PM   #3
NZArchie
Newly Registered User
 
Join Date: May 2011
Location: Christchurch, New Zealand
Posts: 84
Thanks: 3
Thanked 1 Time in 1 Post
NZArchie is on a distinguished road
Re: Append Query that can append to multiple tables

Did you end up creating multiple append queries? If so, how do they link up? I have a single temporary table from a transfertext operation, and I want to be able to parse through it and select which rows I want to import.

I think I will need to use your solution, as the data from each row will be spread across multiple tables

NZArchie is offline   Reply With Quote
Old 05-25-2011, 12:56 AM   #4
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,829
Thanks: 56
Thanked 1,032 Times in 998 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Append Query that can append to multiple tables

you need two separate queries, although they may look very similar. When you design an append query you stipulate the table into which you want the data to append. so you can only append to one table at a time.

Here's a thought, though. If you really need the SAME data to update two different tables, then almost certainly you have a normalisation issue, and your table design could be improved.


[and i now note that this is an old thread!]

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Help - Append Multiple Tables Into 1 Main Table Lobbie168 Modules & VBA 13 07-28-2011 08:42 PM
Query to append multiple tables accessaspire219 Queries 2 05-06-2009 08:04 AM
List Box select error when query has multiple tables rwwilliamson Forms 2 04-13-2008 11:06 AM
Append Multiple Tables? anotherlevel Tables 2 10-26-2006 05:00 AM
[SOLVED] Append query - appending multiple tables quickly gotidude Queries 1 08-12-2005 03:51 PM




All times are GMT -8. The time now is 02:21 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World