Total of calculated data in a query

Posted on 2012-09-21
Last Modified: 2012-09-21
I am using a query to gather data for a report.
i have a caluated field as below.
LineTotal: [tblOrderDetailQuantity]*[tblOrderDetailPrice]
i would like set up another field within that query to give me a total of the result LineTotal.
i have tried =sum[LineToatal]
I understand that this is best done in the query before its goes to the report.
Thanks for looking at this
Question by:petePrinter
    LVL 39

    Accepted Solution

    You can sum in report footer, but not in detail part. Check field name. You can also repeat calculations:

    Author Closing Comment

    i tried it in the page footer( Did not work)
    not the report footer. it worked fine in report footer
     thanks for prompt reply

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now