Recent content by artefact

Hello Plog, I'd really to thank you. I was searching for that for 5 days. You just did it very fast!!!! I was told it was not possible in access. I was advisedto use sql server...

Based on the data your provided SupplierCode, DateDue, ratioOnTime 317, 11/1/2016, .7 317, 12/1/2016, .5 317, 1/1/2017, .8 317, 2/1/2017, .9 317, 3/1/2017, .6 317, 5/1/2017, .2 444, 4/1/2017, .6 444, 3/1/2017, .5 here is the result: SupplierCode, DateDue, avg(ratioOnTime ) 317,1/1/2017/,.67...

Hello Plog, as requested I've updated the table based on your request. Thanks!

I Have attached the access database, with the query and the table as requested. What I would like to calculate for each couple supplier code + months, the average on 3 months regardless if they have been consecutive.

As requested, I attached a sample. Thanks for your help!!!

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...

Hello Plog, Thanks a lot! You were right. Now, I test the parameters before passing value to the function!! Have a nice day. Arte

Hello, Thanks for your quick reply. As requested, here is the function declaration: Function statutelmtmrp(elmtmrp As String, datebesoin As Date) As String SELECT zprpp01.Article, zprpp01.[Désignation Article], zpuddp05.Indice, zpuddp05.[Lead Time], zprpp01.[Document d'achat], zprpp01.[Numéro...

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...

hello Jdraw, The logic would be the following Loop each record on reception table Assign qty received to right order Check if the order line is complete If yes go to the next order line Go back to the loop

Hello arnelgp, Thank you for your help. Could you please be more specific? I mean how can I handle the distribution of the received quantity vs the order? Do I need to code something? What do you mean temporary table? Thanks beforehands for your help. Arte

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...