If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I insert the results of a calculated query in a report?
I have set up a query that sums the total of each of two types of products
that need to be manufactured in the next two years. I have also created a report that gives the total material required for all products. There is one component in the material required which is different depending on which product is being manufactured. I would like to insert the results of the calculated query that I have done in the report so that I could see the following at the bottom of my material report: Total material component A 1000 Total Material Component A1 250 Total Material Component A2 750 -- TS |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error when running Query, but not Report | Blaze | Running & Setting Up Queries | 29 | September 9th, 2005 05:40 AM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Displaying Query Results in a Report | Jess A | New Users | 1 | November 8th, 2004 11:45 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |