Results 1 to 2 of 2
  1. #1
    salisbut is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    52

    Total on Report and multiple queries into a report

    Is it possible to print out a report with just a couple of boxes that have totals from queries? I have configured it so that it gets some of the totals I want, but it prints out tons of duplicates which I am assuming for the total number of records which is not what I want. I am just trying to create a bill that I can send to another company that has the totals.


    Here is how I have my database setup...I have one table that is linked to an excel spreadsheet. This is because each day I receive an email which contains an excel spreadsheet that contains our transacations from that day. I then copy and paste the new cells from that email and into the master excel spreadsheet and it updates my database. In my database I initially had 25 or so queries which took the information for each company and put it into a query. The reason I made twice as many queries was to seperate each company to buy or sell because I couldn't figure out how to grab the information when I got to the report. The table has 10 fields: 1. Counterparty(Company we work with) 2. Product (Power or transmission) 3. Trade (trading number for certain types of transactions) 4. Positiontype (Buy or Sell) 5. Quantity (Number of megawatts) 6. Price 7. Value (Quantity*Price) 8.Begtime(when the transaction started) 9. Endtime(when the transaction ended) 10. Name (many null values, extra designator for different power supplies). I agree that 1 query would be better for each company but how do I just grab the sum of a companies buying into a report or the sum of a companies selling into a report. Something like =(Sum[qryCalpine]![QUANTITY]) where postiontype = Buy ?!?!?! Not sure on this syntax kind of learning access on the fly. I have uploaded the database and the linked spreadsheet. Thanks

  2. #2
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    You could have do a bunch of lookups on the report to display the totals. This would most likely run extremely slow though.

    Quote Originally Posted by salisbut View Post
    Is it possible to print out a report with just a couple of boxes that have totals from queries? I have configured it so that it gets some of the totals I want, but it prints out tons of duplicates which I am assuming for the total number of records which is not what I want. I am just trying to create a bill that I can send to another company that has the totals.
    Here is how I have my database setup...I have one table that is linked to an excel spreadsheet. This is because each day I receive an email which contains an excel spreadsheet that contains our transacations from that day. I then copy and paste the new cells from that email and into the master excel spreadsheet and it updates my database. In my database I initially had 25 or so queries which took the information for each company and put it into a query. The reason I made twice as many queries was to seperate each company to buy or sell because I couldn't figure out how to grab the information when I got to the report. The table has 10 fields: 1. Counterparty(Company we work with) 2. Product (Power or transmission) 3. Trade (trading number for certain types of transactions) 4. Positiontype (Buy or Sell) 5. Quantity (Number of megawatts) 6. Price 7. Value (Quantity*Price) 8.Begtime(when the transaction started) 9. Endtime(when the transaction ended) 10. Name (many null values, extra designator for different power supplies). I agree that 1 query would be better for each company but how do I just grab the sum of a companies buying into a report or the sum of a companies selling into a report. Something like =(Sum[qryCalpine]![QUANTITY]) where postiontype = Buy ?!?!?! Not sure on this syntax kind of learning access on the fly. I have uploaded the database and the linked spreadsheet. Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Merging 3 queries into one report
    By terricritch in forum Reports
    Replies: 2
    Last Post: 06-23-2010, 02:38 AM
  2. Replies: 3
    Last Post: 05-21-2010, 03:57 PM
  3. Including two queries in one report
    By kulanga in forum Reports
    Replies: 1
    Last Post: 03-23-2010, 10:21 PM
  4. Replies: 26
    Last Post: 11-06-2009, 10:16 AM
  5. Total all months in query or report
    By Brian62 in forum Queries
    Replies: 2
    Last Post: 10-23-2009, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums