Search results

  1. A

    Solved Reduce outcomes base on sub query

    I'm struggling to get an ms access query work in order to have the average of value based on 3 months if they do exist in the rows and no necessary consecutives. I'm not able to calculate the way to test if for a specific month (included), I have 3 month in the rows, if so, limit the...
  2. A

    Calculated field

    Hello, I have an access query in which I'm using a calculated field based on a cuom function as shows: Statut: statutelmtmrp([ZPRPP01].[Elément MRP];[ZPRPP01].[Date besoin]) The query runs well, but when I enter a something in the criterion field, access pops me a message saying that I've got...
  3. A

    Received quantity distributed based on order number and order date

    Hello, I'd like to perform a report based on 2 tabless (Order Table and Reception Table): Order Table OrderID (PK)|Item(PK)|Ref|Qty|Order Date 1|1|Orange|5|20/01/2016 1|2|Orange|3|22/01/2016 1|3|Orange|2|22/01/2016 Reception Table RecpID|OrdernumFK|Qty|ReceptionDate 1|1|2|22/01/2016...
Top Bottom