Google Answers Logo
View Question
Q: MS Access query quandry ( No Answer,   0 Comments )
Subject: MS Access query quandry
Category: Computers > Software
Asked by: tronixa-ga
List Price: $3.00
Posted: 04 Nov 2006 12:02 PST
Expires: 04 Dec 2006 12:02 PST
Question ID: 780096
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.
There is no answer at this time.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy