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?

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?

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?