Results 1 to 2 of 2
  1. #1
    raperm is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2017
    Posts
    1

    Queries using calculated fields with fields coming from different tables

    So I'm working with a database that requires a calculation. That's not a problem. The thing is the calculation is pulling data from different tables. I know one way to do it is just to write it out like this:



    ExtendedAmount: Sum([Order Details]![Quantity]*[Products]![UnitPrice])

    But I gotta think there's a better way, or maybe some good online resources showing how to do calculated fields that pull fields from different tables. Any suggestions? I got roped into teaching a class on this, and the pre-fab material they're using gave them a quiz that included the need to do this...and of course none of the prep material ever addressed even one time.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    It seem to me, the query of detail records :
    orderID, Item, Cost, Qty, ExtAmt: Cost*Qty

    the sum(Cost*Qty) would be the total in the footer.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-14-2016, 06:44 PM
  2. Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  3. Calculated Fields in tables
    By dharsh in forum Misc
    Replies: 12
    Last Post: 07-01-2013, 03:07 PM
  4. Replies: 5
    Last Post: 05-02-2013, 05:20 AM
  5. Calculated fields across tables and forms
    By drrob1983 in forum Queries
    Replies: 4
    Last Post: 09-15-2011, 09: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