Search results

Hello guys, Thank you for your support, here's my solution: Option Compare Database Public Sub ComparePlanningWithActuals() Dim dbs As DAO.database Dim rstP As DAO.Recordset Dim rstA As DAO.Recordset Dim strSQL As String Set dbs = CurrentDb() Set rstP = CurrentDb.OpenRecordset("SELECT * FROM...

Hi Larry, Thank you very much for your effort. It looks very good! Nevertheless, this for the case in which we can bring together the planned and actual data as well as the quantity in one row but this is not the case with my data. I wrote a macro in VBA in the other forum. I think you can...

I replied to Ajax in the other forum with an approach that works for most parts but isn't quite there yet. Could you please look over it? Thank you for your help! I appreciate it! Sabrina

I don't want to crosspost further but what should I do now if want to continue the discussion with all members of the two forums?

I will do this now and report my findings with the partial solution.

Hello Larry, what does the solution look like? Unfortunately, I couldn't find one yet. Sabrina

Unfortunately, the data comes from two separate transactions that output two tables that can only be related to each other only by the MaterialID. I just want to track if the actual production of the MaterialID started timely (within the 14 days window before and on planned date), after the...

I have just seen that crossposting is not allowed. I'm sorry for this. I didn't know.

Hello, I have two tables in my database. The first one is chronologically structured as follows: MaterialID PlannedProductionDate PlannedProductionQuantity 255 27.12.2021 192 255 04.01.2022 192 300 15.01.2022 94 300 12.04.2022 188 300 19.04.2022 94 87 19.06.2022...