AnsweredAssumed Answered

Calculate yearly usage on layout

Question asked by david583 on Jan 9, 2013
Latest reply on Jan 10, 2013 by david583


Calculate yearly usage on layout


     FM Pro10 & 11, Server 11. Network shared Windows system, XP & Vista. 10 users

     I am trying to work out parts usage over the year for individual parts.

     I have a 'Parts_Inventory' table and a 'Job_Card' table, joined by a 'Parts_Usage' table. Part Number and Job Card Number are the foriegn keys in the usage table.

     What I would like to be able to do is display for each part number in my Inventory layout, the quantity used so far this year and in another field, the quantity used total last year.

     Can this be done with live calculations rather than having to produce a grouped report?