Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Jay10634

  1. Jay10634

    How to summarize fields from different levels?

    Ok, let's see if I can break this down: Each Item has unlimited locations. Each location can have many transactions (receipts, xfers, stock issues, etc). These values are stored in three records: Item Master, Item Locations, Item Trans. I am trying to take the Sum of the QTYONHAND from the...
  2. Jay10634

    How to summarize fields from different levels?

    I am trying to create a report to show a QTY for a value based on several different levels. These values come from three different records. Transaction level, a "location" level, and finally a Total value level. When I sum the "location" and compare it to the Total level, it...

Part and Inventory Search

Back
Top