Results 1 to 2 of 2
  1. #1
    mikemowry is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    1

    Calculation with two tables

    Hello, newbie question here.

    I have an inventory report where I want to compare the sum of inventory counted for each material with a single record from book value to display an overage or shortage



    There are two tables, LQUA and M52 LQUA contains the material, storage bin and total stock shown above. Book value comes from a single record for each material in the MB52 table. I need the empty red outline to show the sum of total stock (874) minus the book value (1047) For this material the answer would be -173 representing a shortage of 173 items.

    Thanks in advance for the assistance.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Welcome! Your picture didn't come through. Try attaching it in the Go Advanced area.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 04-26-2016, 05:24 PM
  2. Percentage calculation using two tables
    By vthompson9100@gmail.com in forum Queries
    Replies: 8
    Last Post: 04-16-2015, 02:18 PM
  3. RelationShip Between Tables & Calculation
    By braveali in forum Access
    Replies: 5
    Last Post: 01-01-2014, 04:15 PM
  4. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM
  5. How to do calculation???
    By latestgood in forum Forms
    Replies: 0
    Last Post: 05-18-2011, 11:11 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