how to store queryA result into queryB?

[rose.zhu295@gmail.com]

Hi I have queryA at the moment running some looping code and wanna store the result generated every time into queryB. Problem I have is that the queryA overides itself while looping and what I need is to store the result into queryB before queryA overides itself. And at the end I will have queryB storing all running results so that I can generate a report based on queryB result list.

[June7]

What do you mean by 'running some looping code' - is this actually VBA code manipulating a recordset object? Why would data be 'overwriting itself'? Only an UPDATE sql action or VBA code manipulating recordset can do that. Why would you change data in records if you need the original data for report?

[rose.zhu295@gmail.com]

QueryA is running VBA which is filtering an original rawdata table with duplication in a field called [Description]. QueryA (index=i) firstly displays the same [Description] records (Description 1) with their entire rows including fields called [items] and [Price]. What I need is the sum of [items] and sum of [Price] for all the Description 1 into QueryB (which is only one row with Description 1, sumofitems, sumofprice). Then VBA lets QueryA (index = i+1) display all Description 2 records and their entire rows. The final report will display all QueryB records with only unique records in [Description] field (Description 1, 2,3...) and sumofitems and sumofprice. Sorry for my expression...

[June7]

Sorry, can't follow that. If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

Try telling readers what you are trying to do in plain English. Forget the query stuff and jargon until readers have some concept of WHAT you are trying to accomplish.
You might even concoct an example:
a)this the data I have
b) this the output I need...

[pritesharyan]

do something like shows in this image. may help you . thanks.

[orange]

Try telling readers what you are trying to do in plain English.

This is the sort of thing that will help readers understand your "business opportunity/issue".(adjust and extend as appropriate)
---We are jewellery manufacturer... We are automating our inventory control system. We purchase semi finished items and raw materials from various suppliers. .....

Tell us WHAT you do and what you are trying to automate --plain English.

Here is a free, generic data model that may help.
I recommend you start by working through this tutorial to understand database and table design, relationships and Normalization.
Good luck with your project.