Results 1 to 5 of 5

Thread: [Resolved] How to place a Total in a Report?

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Posts
    103

    Resolved [Resolved] How to place a Total in a Report?

    I have a table (tblPO) which contains these fields:

    1. ItemNo
    2. PONo
    3. SubTot

    Now, I have a query that states:

    SELECT Sum([subtot]) AS Total
    FROM tblPO;

    The thing is, I don't know how to combine it with the aforementioned 3 (ItemNo, PONO, SubTot) and how to display only one Total in the report.

    What I like as a result would be on the attached image. Any suggestions would be appreciated. Thanks.
    Attached Images Attached Images  
    Last edited by sirkeled; Sep 8th, 2006 at 07:49 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
  •  



Click Here to Expand Forum to Full Width