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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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