I have to take the results of an MS Access query that produces
multiple record and place those results into one record on a table. To
make things (hopefully) easier, I have the field names in the table
matching the name of each record from the query.

---

Clarification of Question by tronixa-ga on 04 Nov 2006 12:10 PST

To be specific, the query produces the following result:
Rec     Price       Mineral Type     Region
___     ______      ____________     ___________
1        $1.00        Tritanium      Sinq Liason
2        $2.50        Pyerite        Sinq Liason
3        $25          Isogen         Sinq Liason

The table that I want to put the values in is only one record and is
listed as such:

Rec    Tritanium      Pyerite   Isogen      Region
___    _________      _______   ______      ______
1       $1.00          $2.50     $25        Sinq Liason

The problem here is that I want the data from the query to be inserted
into the table as such but due to the way the query is output I don't
know how to do this. Any help you can provide would be great
preferably without the need of any Visual Basic because I don't know
much about using VB in MS Access.
Keep in mind that the data base will be used to insert multiple
regions so nothing can be set static. The only thing that will stay
static are the mineral types (Tritanium, Pyerite, Isogen, etc...). The
prices and regions will change. The data needs to be appended to the
table from the query results (add a record). Due to the nature of the
database it is impossible to change the way that the minerals are set
up in the table to make it more compatible with the query. This is the
only way I can do this.
Thanks!!