Combine multiple queries into one report, kept separated, with total sum.

[C6067]

I'm trying to combine 3 queries into one report. However, I need to keep them separate. In addition, the various totals from each query need to be at the top including a final sum of all three.



Thank you for your help.

[orange]

How about stepping back and describing what you want in plain English.
We know nothing of your queries, the subject matter nor anything else.
We can't help you until you get us to understand WHAT the issue/opportunity is.

[C6067]

I apologize for not being more forthcoming with information. This project is quite involved and has numerous levels. I was trying to keep my question and description to a minimum.

I am working on a project that requires I maintain a database of over 500 images/photographs and provide weekly updates. For each image it is necessary I keep track of my research, copyright information, permissions, photo material information, correspondense, fees, location and uses within the project, etc. (90 columns in total). There are five main sections to the project, each section with up-to 10 subsections, and I have created a query for each section.

My client has asked for a weekly fee estimation report and they would like to start this week with three of the five sections. For each section, they have asked for the following information of each image: ID#, FEE ESTIMATE, SECTION, AREA, CORRESPONDENCE, DESIGN REQUIREMENTS, LEGAL RESTRICTIONS, TILE, LENDER, and THUMBNAIL of the image. Each column will have an associated count, except for the fee estimate which will have a sum. This information has been included in each associated query.

For this week's report I have been asked to submit the information mentioned above for three sections (not combined) and their associated sums, into one report. I am also to include the final total sum for all 3 sections combined.

I hope the additional information is of assistance and I greatly appreciate any guidance.

Thank you

[orange]

Do you have a data model --tables and relationships?

[C6067]

If you mean a main database, yes.

Sorry, not up on all the terminology.