If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Append Queries to One Table
I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change the select Query to an Append query but if I run 5 append queries each "count" is dropped into a new record. Is it possible to have each append query drop the "count" into the same record?
|
#2
|
|||
|
|||
Multiple Append Queries to One Table
Sounds like you really want to be running update querys
"wpshop" wrote in message ... I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change the select Query to an Append query but if I run 5 append queries each "count" is dropped into a new record. Is it possible to have each append query drop the "count" into the same record? |
#3
|
|||
|
|||
Multiple Append Queries to One Table
I am using the queries to calculate totals off of a main table and I need to post these totals to a secondary table. I have to post them to a secondary table because I need a report with all historical totals and the main table does not include historical information. I have tried working with update queries but it does not appear they will fit the situation.
----- TPratt wrote: ----- Sounds like you really want to be running update querys "wpshop" wrote in message ... I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change the select Query to an Append query but if I run 5 append queries each "count" is dropped into a new record. Is it possible to have each append query drop the "count" into the same record? |
Thread Tools | |
Display Modes | |
|
|