Multiple Append Queries to One Table

G

Guest

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?
 
T

TPratt

Sounds like you really want to be running update querys


wpshop said:
I have a table with 5 fields. Each field's value can be calculated by
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Append but no table? 2
Append Queries 4
Append problem 1
Append to two different tables 23
Append query - Append to table with Autonumber field 2
Add Table Name as Field in an Append Query 1
Append Queries 5

Top