Search results

  1. J

    Sumifs in access

    Guys I need some help with sumifs in access. HEre are my tables: TAble1 = Material and Quantity available ItemCode Qty A 124 B 45 Table2: Product and Priority Prod Priority Prod1 1 Prod2 3 Prod3 2 Prod4 4 Table3: This is the master table which should tell me if for the product I have...
  2. J

    Conditional Rolling Sum

    Hey Guys, Am a total newbie, so this one should be real easy to solve for you folks. Have a table/query result Sr.NO Name Amt.Tot Amt.Needed Date 1 Mark 100 24 1/1/12 2 Mark 100 80 1/5/12 3 Tom 150 12 4/5/12 4 Tom 150 45 6/5/12 5 Joe 50 23 3/3/13 Need to add a field which is Amount.LEft so...
  3. J

    hey

    Hey folks, this is joe from Mumbai india, total newbie to access, hardly a programmer, though have fairly expert excel skills. Technically im into project management, but im sure there is atechie hidden in me somewhere. Regards, Joe
  4. J

    Rolling Sum in Access

    Hey Guys, Am a total newbie, so this one should be real easy to solve for you folks. Have a table/query result Sr.NO Name Amt.Tot Amt.Needed 1 Mark 100 24 2 Mark 100 80 3 Tom 150 12 4 Tom 150 45 5 Joe 50 23 Need to add a field which is Amount.LEft so that the table looks like this Sr.NO...
Back
Top Bottom