Update Multiple Records from Multiple Query Results

Greetings folks! I have a delimia I've been working on today that I think I'd like to get some feedback on please. I have a client that wants me to produce a financial report for his business and export it to an Excel output from MySQL. That usually wouldn't be a problem. However, my problem is that to obtain all of this information I have to gather it from (5) different locations and then do some calculations.

My Dreamweaver table with (5) queries with repeating regions.

So I have (5) Queries and then I'd like to store these results in one table. Ultimately from that table I'll export the report to Excel (but that's not my issue).

This is my actual output from the Dreamweaver script above.

The issue is I'm having no luck taking my results output and either inserting or updating the table I have ready for the final content.
The image below should give you a better idea of what I'm trying to accomplish.

Thanks in advance!

this is going to be a tough one to accomplish, but the general gist is that the insert will need to be inside of repeat regions code.

you need to perform the insert for the first records of each of the recordsets, then move each of the recordsets to the next record, and perform the insert again.

Where you have 5 repeat regions, the exact code is going to be impossible for me to give you here, but I think we would be able to hand code this quite quickly in a premier ticket. See the support landing page for details on signing up for a premiere ticket where:
support/

I submitted a Premier Ticket request about a hour ago. Thanks.

Good morning! I hope that we can initiate a premiere ticket for this issue today if at all possible. I submitted the ticket late Friday afternoon CST. However, I didn't receive any notification that you received such submittion on your end, nor is there any insertion of such into my Support History.

Just wondering if I failed to submit the ticket. Please confirm receipt.

Thanks! :)

I have forwarded this to our sales department, they should be notifying you shortly of status of your appointment.